multiple reports from single query

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
 
T

tina

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
 
D

Douglas J. Steele

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.
 
A

Alec Green

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
Multiple Reports – Same Query – Underlying Data Changes Frequently 1
List box for reports 1
Calculating values from 2 subreports.................. 1
Adding values from sub reports in the main report 8
Adding values from multiple sub-reports 1
Stop header/footer appearing in subreport 1
Saving multiple reports to 1 file 1

Top