Query Criteria from excel file?

[Paperclipper]

Hi everyone! I am a novice at Access, and wanted to know if there was any better way to run a query that includes a long list of criteria...

The field is four character format, and I need all the records that are btwn 8400 and 9700 (does this include 9700? I assume not?), begin with the characters AC, and btwn H110 and H128...

I currently have something like the following in excel:

Like "AC*"
Between "8400" and "9700"
Between "H110" and "H128"

Is there anyway to do this without typing them all into the query design view? My list is actually about 100 different subsets...

Thank yoU!

 

[ChrisUK]

Hi,

Try this - you'll need to alter the column names to suit but you should get the drif

SELECT * FROM TableName where
columnNameOne like "AC*" and
(ColumnNameTwo >= "H110" and ColumnNameTwo <= "H128" and
ColumnNameTwo >= "8400" and ColumnNameTwo <= "9700")

Hope this helps!

Chris