Crosstab Query

[Guest]

Hello

I've tried using the Crosstab Query example as provided by Litwin, Getz & Gunderloy book. The report is dynamically generated, but if I only have a two column crosstab query I get the following errors

Can't find field txtData1
Error #: 246
Jet Database engine does not recognize '[02/04/2004]' as a valid field name or expression

02/04/2004 is the second column heading in this case. Any clues
Thanks in advance

Eric

 

[Duane Hookom]

No offense to Masters but I don't think their solution is the best. If you
are using dates as column headings, there may be a much better solution.
There are samples of more flexible crosstab reports at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

It hard to make specific recommendations since we don't know your
specifications or the sql of your crosstab.

--
Duane Hookom
MS Access MVP

Hello,

I've tried using the Crosstab Query example as provided by Litwin, Getz &

Gunderloy book. The report is dynamically generated, but if I only have a
two column crosstab query I get the following errors:

Can't find field txtData13
Error #: 2465
Jet Database engine does not recognize '[02/04/2004]' as a valid field name or expression.

02/04/2004 is the second column heading in this case. Any clues?
Thanks in advance,

Eric