Access Report Filter Question

  • Thread starter Thread starter bgreer5050
  • Start date Start date
B

bgreer5050

When I look at the properties for my report there is a filter and
filter on value. How do I add a filter to this report. I am unsure
what goes in the filter value. I imagine I enter the name of a filter
in this box and put the filter on; but how do I create the filter
itself. Is this a function that I must create?

I know how to filter using the criteria in the qeury; I would like to
be able to filter at the report properties level so I do not have to
create a new query.

Thanks for the help.

P.S. I have a field called "Bin" and I want to filter the report where
Bin IsNotNull.
 
One easy way is to Open the report with a 'Where' criteria. Eg

DoCmd.OpenReport "MyReport", acViewPreview, , "Not IsNull(Bin)"

This way you do not need to embed filters in the query or the report.
You can build up this criteria string in code from values input into a
form, and so be quite flexible.
 
Back
Top