access 07 report/design view/from query

C

cathyh

in access 2007, if i create a report in design view, and choose to see the
field list, i can see fields from all tables. is it possible to see a list
of queries so that i can base the report on fields from the query? i'd
prefer not to use the report wizard.
thank you.
 
C

Clifford Bass

Hi Cathy,

Set the Record Source property for the report to the desired query
before viewing the fields list.

Clifford Bass
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Weekly Report 2
Need some PWA help 0
How to Create an S-Curve from Custom Field? 0
Set as Default Template not working 0
Report Design View & Query Fields 2
Union query in Design View? 2

Top