Natahn,

An Access news group might be a better place to ask a question like this.

I don't use MS Query at all - but in the meantime, you could use a helper column of formulas like

=OR(A2="Value",D2="Value")

and pull in records where that formula returns TRUE.

HTH,
Bernie
MS Excel MVP


"Natahn" wrote in message
...
I am trying to return a set of data from an Access database, into Excel using
MS Query. I have two different cells in the database that can contain the
same value. I need to know how to return every record that has the same value
in EITHER cell. All I have achieved so far is returning those records that
have the same value in BOTH cells. If I try to exclude values that I do not
want in one cell, it also excludes records that contain the desired value in
the second cell.