Query Criteria Expression

[Ranger7913]

I am looking for an example of a criteria expression. I have a query set up now that asks for a "Location" and "Start Date", "End Date". I would like to have the query return all "Locations" if when prompted to enter a location, I leave it blank. I know I could go into the query and remove the Location criteria when I want to return all records but is there an expression I can use to allow me to return all records or specific records based on a criteria statement? Thanks for any help.

[JoeM]

Enter this is the criteria for Location:

Like [Enter Location] & "*"

[JoeM]

Enter this is the criteria for Location:

Like [Enter Location] & "*"

Just note that it will return all entries that begin with whatever you enter in (or everything if you leave it blank).

[Ranger7913]

Thanks. That worked perfectly.