report based on crosstab

[Guest]

I have a crosstab query with date parameters. I would like to create a
report based off this query so I can input dates, but when I go to the report
wizard and choose my query, there are no fields. Can this be done? Thanks,

 

[Roger Carlson]

Creating a report based on a crosstab is problematic because the field names
don't necessisarily stay the same. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"CrosstabReport.mdb" which illustrates one way to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Arvin Meyer [MVP]]

Try this search in the Knowledge Base:

http://support.microsoft.com/search...D=1033&spid=global&query=Crosstab+report&adv=