Access Report Filter Question bgreer5050[ at ]yahoo.com 29.09.2006 15:45:02 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.

Re: Access Report Filter Question "Sprinks" <simon.gunning[ at ]ntlworld.com> 29.09.2006 16:03:15 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.