Can anyone tell me how to design a Query whereby the results produced are records where ANY of the Criteria entered in a number of fields are satisfied?
Normally, all criteria have to be met (as I understand it) - can I design it so that only ONE (any) of a series of entered criteria in DIFFERENT fields are met?
For example, I have to enter codes in three fields but would like to do a single search / Query for a code in ANY / ALL of those three fields.
I hope this makes sense.
Thanks
Al