help returning the same values from two different cells
 

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.

help returning the same values from two different cells
 

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.