Limit Report

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

Guest

I have a complex report that is dependent on a number of queries. The end
result is created as a Report in Access.

I want to limit the fields to only items after a certian date. Something
like < 1/1/2007. Since the queries have gotten complex. Is there a place in
the report area to limit the result?

Any help is appreciated.
 
Zanstemic said:
I have a complex report that is dependent on a number of queries. The end
result is created as a Report in Access.

I want to limit the fields to only items after a certian date. Something
like < 1/1/2007. Since the queries have gotten complex. Is there a place in
the report area to limit the result?
Click to expand...


Not really. You should try using a form text box for the
criteria. This way, any query can refer to the text box
without any further user interactions.

OTOH, if your queries were based on a query (instead of a
table) that filters the dates, then your existing queries
would not be concerned with the date criteria.
 
Back
Top