Need a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field called position code (PC), this can have many different
values. What I need to pull all PC's that are 1010, if not then 1005. but not
both. How do I go about doing this?? The 'OR' Function pulls both.
 
Clarify if I rephrase your question properly:

Each PC has unique ID but can belong to different position codes in the same
time.
Lets say, PC with ID = 001 can have 2 records in your table, one with
position code 1010, another with position code 1005. You want to see PCs
that belong to either 1010 or 1005, but not to both categories in the same
time. Correct?
 
Back
Top