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

Top