access 07 report/design view/from query

  • Thread starter Thread starter cathyh
  • Start date Start date
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.
 
Hi Cathy,

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

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

Can't create a report from my query in Access 1
Report Design View & Query Fields 2
Access 2007 Strange Report Design Behavior 8
Access 2007 report to many fields 1
parameter prompt problem 2
Can I Manually Check/UnCheck Boxes in Report View And Have Them Stay? 2
Crosstab report - handling Null fields 4
Coordinating the sort order in a report with the underlying query 2

Back
Top