I have reports which all rely on one query. The query looks something like this:


ID VolumeA VolumeB VolumeC VolumeD



Now, I have four separate reports. ReportA is filtered to bring back all lines that VolumeA <> 0. ReportB is filtered to bring back all lines that VolumeB <> 0. ReportC and ReportD are the same way.

However, the filter just does not seem to work for ReportC as it brings back every single line. When I check the properties... ReportC's filter is gone! So I type it back in, and the report works fine. I save it and reopen it in design view to make sure the filter is still there (which it is).

However, when I try to rerun ReportC... Once again the filter disappears and I have to retype it back in.

What is going on?

How are you setting the filters?