Having the same criteria in multiple fields of a query

[strKohmM]

I have a table like the following:

A 101 12/13/2011
101 A 12/4/2012
101 A 12/4/2012
101 B 12/7/2012


I am creating a basic query but looking to retreive the entries when "A" is in field 1 or field 2.

Basically retreive this data:
A 101 12/13/2011
101 A 12/4/2012
101 A 12/4/2012

Any suggestions?

 

[vbaInet]

You have two options:

WHERE Field1 = "A" OR Field2 = "A"

OR

Concatenate Field1 and Field2 together and search within the concatenated field. The first option is preferred.

 

[strKohmM]

Is that something I would add in SQL view?

 

[vbaInet]

That's right. In the Criteria row of the Query grid. Or you can do it directly in the SQL View.

 

[strKohmM]

In criteria for both fields? Or just one of the fields?