Filter for Same Value in Two Fields

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

There are two fields in my query. "From" and "To". For sake of ease, let's
say both these fields are US Cities. How can I pull all the records that show
shipped "From" Denver and that show shipped "To" Denver? Thank you in advance.
 
Just puting Denver in the criteria sections does not work. I need to write an
If statement of some kind (ie- If "From" or "To" = Denver Then show). Or an
Iif statement (Iif ("From" or "To" = Denver, show, hide). How would I do
this? Thanks.
 
Just puting Denver in the criteria sections does not work. I need to write an
If statement of some kind (ie- If "From" or "To" = Denver Then show). Or an
Iif statement (Iif ("From" or "To" = Denver, show, hide). How would I do
this? Thanks.
Click to expand...

Please define "does not work" - in particular open the query in SQL view and
post the SQL here, and indicate what works and what doesn't work. Or, post the
relevant fieldnames of your table (From, To, and the fields that you want to
show, and any other fields to which you're applying criteria).

The OR logic *is the correct solution*, it does work correctly (if done
correctly), it does not require any IF or conditional logic.
 
Your initial reply did not show up until after my last post. Thank you, the
method you suggested in that post worked.
Click to expand...

And it is the method that I suggested in my response as well, which must have
been phrased confusingly... sorry about that, and glad that John Spencer's
good advice worked for you!
 
Back
Top