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.
Sprinks - 29 Sep 2006 17:03 GMT
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.