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?
 
You must log in or register to reply here.

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

Query to take count and find most likely 4
Duplicating values to empty field 6
calculating Subtotals in Access Reports but under certain criteria. 5
Exclude items in a query 2
How to subtract a number from a Mergefield? 0
Query to group similar number combinations? 4
Stacking queries and Calculations 3
creteria using other fields 1

Back
Top