Excluding certain values

  • Thread starter Thread starter tcek
  • Start date Start date
T

tcek

i have a query where the same individual may have more than one extry for a
certain column (ie: po box and and home address). I want to look for those
individucal with a PO box equal to "**100**" but not a home address equal to
"**200**". i am not sure how to do an "equal to" and "not equal to" query on
the same column (all at the same time). thanks in advance
 
Back
Top