Query Criteria

[vnms2001]

How can I get a Query Criteria To Select All Records or specific records in query design section.
I have a table that shows many departments with credit card transactions. I like to run a query to see specific department, or have an option to see all the departments when the query is run.

Please help.

thanks

[June7]

Dynamic parameterized query using LIKE and wildcard is one way. Review:

http://allenbrowne.com/subquery-01.html#TopN

http://www.datapigtechnologies.com/f...earchform.html

http://www.datapigtechnologies.com/f...mtoreport.html

[vnms2001]

Thank you so much. This is what I was looking for.