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
 
Back
Top