multiple reports from single query

  • Thread starter Thread starter Alec Green
  • Start date Start date
A

Alec Green

Hi,

Is it possible to have 3 reports from one underlying query, but where one of
the report fields VALUE has a different criteria - for example

report1 - VALUE <1000
report2 - VALUE >1000 but <5000
report3 - VALUE > 5000
(all from one query)

Thanks

Alec
 
you can filter the report at runtime by adding a WHERE clause to a
OpenReport action in a macro or VBA procedure. look up the OpenReport topic
in Help and see if it will fit your situation. post back if further
questions.

hth
 
You can use different filters for the 3 reports, or if you're opening the
reports from VBA code, you could have a single report, and call it 3 times,
passing a different Where clause each time.
 
hi, thanks for quick response, have looked at the help - still not 100%
could give me an example

Thanks
 

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

Multiple Reports – Same Query – Underlying Data Changes Frequently 3
Calculating values from 2 subreports.................. 1
Multiple Reports – Same Query – Underlying Data Changes Frequently 1
Adding values from sub reports in the main report 8
Stop header/footer appearing in subreport 1
Adding values from multiple sub-reports 1
Report Criteria 2
Saving multiple reports to 1 file 1

Back
Top