Fields Not Seen

[Wesley Morgan]

What could cause the fields from a crosstab query not to be shown in available fields window of report wizard?
I have a crosstab query that works great and list all data requested. When I try to use the report wizard to create a report from the query, none of the fields are shown in the wizards box.
All tables, and other query fields can be seen as you select table or query. Why does this one behave different?
Thank you,
Wesley Morgan

 

[Wesley Morgan]

In working with the query that I am using for the report wizard, I find the following reactions.
If I have parameters set to represent controls on form then report wizard cannot display the available fields from query.
If I delete the parameters the fields are visible.
If I put a criteria like " >=#08/03/2003# And <=#09/04/2003# "
all fields are visible in the report wizard;however, if I put the criteria to look at controls in a form " >=[Form]![frmRptDateRange]![txtbegindate] And <=[Forms]![frmRptDateRange]![txtenddate] " the fields are not visible.

I have also trien the Between [ ] and [ ] syntax.

Anyone feel like taking this one?

Thank you,
Wesley Morgan