Query criteria with option to select all records (1 Viewer)

[Rats]

I am developing an Event Management DB for business training courses. I have an attendees table with a link to CompanyNames. I wish to be able to produce an attendees report based on the CompanyName ie all attendees from the selected company. I have done this by using a dropdown of companynames on a Criteria selection form. This works well.
What I would also like to do is print the same list without the companyName criteria. I am aware I could make another query but was hoping that maybe there is a way of setting up the criteria in the companyName field so that it could accept either a company name or ALL company names.

Hope someone can help.

Thanks

Peter

 

[pbaldy]

One way:

http://www.mvps.org/access/queries/qry0001.htm

 

[Rats]

Thankyou

That was what I was looking for. Thanks a lot