Entering Criteria in a Query

[wdrspens]

I have a query upon which a report is based and in order to ensure that I obtain all the records relating to a particular customer I use the following expression in the Criteria row under the Names field: Like "*" & [Enter Customer Name] & "*"


Very occasionally I wish to report on only one record of a particular customer and can achieve that by using [Enter Number:] in the Criteria field on the same line, and then entering both the number and the name when running the query. However if I want all the records, rather than a specific record, I now do not get any of the records for the given name.
Can anyone suggest how I can get all the relevant records most of the time but only one record occasionally for any given name.
Many thanks
David

[kennejd]

How about Like [Enter Number:] & "*". When you want all records, enter * at the prompt.

[wdrspens]

Thanks - that works at the moment and should continue to work. Do I have to enter the "*" at the prompt, or can I just hit Enter?

Many thanks

David

[kennejd]

You should be able to just hit enter...try it and see.

[wdrspens]

I have tried it and I can just hit enter. Thanks