create a report using queries

[helpaccess]

I would like to create a report using queries instead of tables. I go a blank design and all that comes up is the tables for me to use how do I get the queries instead.

 

[pbaldy]

The report wizard should allow you to select a query. If the report is already designed, you should be able to see both queries and tables listed in the Record Source dropdown. If not, you can just type in the name. What version?

 

[helpaccess]

Access 07 I have the queries set up but I can nt select them only tables.

 

[pbaldy]

Exactly where are you looking? I just checked 2007 Northwind and queries show up both in the wizard and in the Record Source dropdown of the report's properties. Offhand I don't know of a place where that option can be set.