filter by form

  • Thread starter Thread starter Chuck D
  • Start date Start date
C

Chuck D

I have a report that I want to do a filter on based on what someone selects
on the form. How can I do this. Anyone one have an example of this?
 
Chuck D said:
I have a report that I want to do a filter on based on what someone selects
on the form. How can I do this. Anyone one have an example of this?
Click to expand...

If you want to offer the user lots of text boxes where they can enter
limiting values, and you then filter the report based on whatever
combination of values they choose to use, download this example and see how
to build the filter string:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Although the example applies the filter to the the form, it's identical for
the report. It shows how to work with different field types, partial
matches, range of dates, etc.
 
Back
Top