tacieslik
02-07-2002, 06:35 AM
My table contains a combo field with the following:
Inbound
Stored - Avalible
Stored - Sold
Shipped
My query should only contain records that have the 2 stored values. So there should be no records with 'Inbound' & 'Shipped'.
I assume there is a way of doing this using the 'Criteria' function, but I'm unsure how to use it. Any suggestions?
Inbound
Stored - Avalible
Stored - Sold
Shipped
My query should only contain records that have the 2 stored values. So there should be no records with 'Inbound' & 'Shipped'.
I assume there is a way of doing this using the 'Criteria' function, but I'm unsure how to use it. Any suggestions?