helpaccess
11-10-2009, 08:31 AM
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.:(
|
View Full Version : create a report using queries helpaccess 11-10-2009, 08:31 AM 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 11-10-2009, 10:21 AM 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 11-10-2009, 11:43 AM Access 07 I have the queries set up but I can nt select them only tables.:( pbaldy 11-10-2009, 12:03 PM 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. |