Query for multiple values to display "All"

[vicsaccess]

I have a field for location ID in my temporary table, this is a numeric value based on the location of the location that entered the record. Most times this temporary table will be based on a single location but on occasion it will be based on all locations. My form that queries the reports that are based on this temporary table displays the parameters of the temporary table in text boxes and is based on a query. Currently the form displays items like the start and end date of the loaded record set in the temporary table. I would like to add another text box to my form for the loaded location in the temporary table but how do I query so that if there are multiple location ID's to display "All Locations"?

[nrgins]

Add a text box for the user to enter the location ID. Make * the default value of the text box.

Then, in your query's Criteria row, under Location ID, use the Like keyword to reference the text box, e.g.:

Like Forms!MyForm!MyTextbox

where MyForm and MyTextbox are the names of your form and textbox.

That will return records for all locations if the value of the textbox is *.

[vicsaccess]

Thanks, but I'm not trying to query all. I'm looking for a way to distinguish if there is more than 1 location in the forms recordsource query to display "All Locations". If the forms query finds that there is more than one location ID in the field then return "All Locations".

[nrgins]

In that case, you'll have to provide more information about how your data is stored. A screen shot of the table where locations are stored in design view would be helpful. Or at least the field name and type where locations are stored. Is this a single value field with multiple records; a multi-value field; etc? Without knowing how your data is stored, not much I can do to help.