Report losing filter?

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

 

[judy jennings]

I am having the same problem. Not sure what is going on.

 

[Jim/Chris]

Why not base the report off a query that contains all your
filtering.

Jim

 

[Judy Jennings]

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

 

[proutym]

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.