How do I modify the query on which my report is based

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to modify the query on which my report is based without going into
design view on the query itself. Is there any way in which I can view the
query from within design view on my report to modify the query (just
slightly) on the fly?
 
Sure. Open the report in design view and open the "Properties" box. Click
the "Data" tab and you will see the "Record Source". Click the button [...]
to the right and it will open your query.
 

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
Union query in Design View? 2
Cross Tab Report Vs Dynamic coulmns 0
Access Access Report Works on One Machine but not Another 3
Displaying Last Date in Report Footer 2
order of Parameter prompts Changed 1
access 07 report/design view/from query 2
Crosstab report - handling Null fields 4

Back
Top