Report losing filter?

  • Thread starter Thread starter dlw
  • Start date Start date
D

dlw

When you add a filter statement to a report, is it
supposed to save that with the report? When I put in the
filter, do a save, exit access, open database again, the
filter is gone.
 
In response to your suggestion:
I have a query that gathers all of the information needed
for the sales people. The end user produces the report
monthly and distributes. When the sales person checks
theirs and finds errors....they can correct them in
the "owner system" outside of access and then wants that
report re-ran.
Instead of creating a query for each sales person.....I
use a filter to let the user input the particular sales
person to only produce that report.

Judy
 
Infuriating, isn't it. My get around is to put a prompt in
the query as criteria:
[Enter Sales Rep ID (* for all):]
-or-
like [Enter Sales Rep ID:]

I would like to expand on this to be able to enter
multiple criteria from one prompt. will investigate.
 
Back
Top