column headings of days

[Tim Brown]

I have a query that is using a heading of Format([fld1date],"Short Date") and
with no column headings properties. It gives me a sum value based on the
date ranges that i specify.
Normally this has worked. Now I have linked some of the queries behind the
cross tab query to a form value and I get an error. It identifies that the
expression is not valid field name or expression.

In my investigation and found that if i put column headings like
"Jan","Feb","Mar" the query works but the data is not accurate.

Any suggestions

Thanks Tim,

 

[Jeanette Cunningham]

Hi Tim,
if you google on - dynamic crosstab queries - you will get several hits that
should help with this


Jeanette Cunningham

 

[Tim Brown]

Most of the searches are how to do a dynamic report. This is an error with
the query it self and the column headings property

Hi Tim,
if you google on - dynamic crosstab queries - you will get several hits that
should help with this


Jeanette Cunningham

I have a query that is using a heading of Format([fld1date],"Short Date")
and
with no column headings properties. It gives me a sum value based on the
date ranges that i specify.
Normally this has worked. Now I have linked some of the queries behind
the
cross tab query to a form value and I get an error. It identifies that
the
expression is not valid field name or expression.

In my investigation and found that if i put column headings like
"Jan","Feb","Mar" the query works but the data is not accurate.

Any suggestions

Thanks Tim,

 

[Jeanette Cunningham]

Hi Tm,
post the sql of your query
explain a bit more about the inaccuracies

Jeanette Cunningham

 

[Tim Brown]

I believe that I have resolved the problem.

I found another post in this group that talked about retrieving data from a
form. it suggested adding parameters for the form fields in the opening
query. As things go I found this 1/2 hour before I needed to leave.

Thanks for your help.
Tim

Hi Tm,
post the sql of your query
explain a bit more about the inaccuracies

Jeanette Cunningham

I have a query that is using a heading of Format([fld1date],"Short Date")
and
with no column headings properties. It gives me a sum value based on the
date ranges that i specify.
Normally this has worked. Now I have linked some of the queries behind
the
cross tab query to a form value and I get an error. It identifies that
the
expression is not valid field name or expression.

In my investigation and found that if i put column headings like
"Jan","Feb","Mar" the query works but the data is not accurate.

Any suggestions

Thanks Tim,