One criteria for many fields

[Guest]

I have a table containing three fields with dates. I want to create a query
with a criteria such as [EnterDate] so the result would show all rows that
have this date, no matter in which one of these 3 fields it is. I have been
trying to do this by have the same criteria, [EnterDate] for all three fields
but then of course no rows show up as there are not any rows where the same
date appears in more than one field.

I have also been trying to use the word "or" but it is not possible before
the first criteria in a field.

Does anyone know a solution to this problem?

Thanks

Andreas

 

[Allen Browne]

In query design view, under the Criteria row are more rows labeled Or. Place
your [Enter Date] on different rows under the 3 fields.