help returning the same values from two different cells

N

Natahn

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.
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup values, compare and paste 1
Compare 1 cell to column of cells returning adjacent cells info? 1
greater of two values 1
Sumproduct is returning irregular values 11
Formula Help-returning False 3
Returning a value from the same row using two variables 1
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b 2
formula finds values in apparently blank cells 1

Top