View Full Version : Query depending on a field value


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?

tacieslik
02-07-2002, 06:50 AM
Forget it. I've managed to do it.

TAC