query

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

If i need to run a query and want it to pull many variables within a field
what would i use in the criteria?
Example Carrier field, i need it to pull carrier 3552, 4691,9801 and 4600.
Thanks
 
One way when you got LOTS of criteria is to create a table for them. Then
use the table in criteria like this --
SELECT [DD], [RR], [YY]
FROM MyData, MyCriteria
WHERE [ZZ] = MyCriteria.Data;
 
If i need to run a query and want it to pull many variables within a field
what would i use in the criteria?
Example Carrier field, i need it to pull carrier 3552, 4691,9801 and 4600.
Thanks
Click to expand...

A criterion of

IN (3552, 4691, 9801, 4600)

will work. It's somewhat harder with a parameter query!
 
Back
Top