Querying by multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column in my table that contains case ID data. There are about one
thousand case id's. I'd like to query records that correspond to 53 Case
Id's. I've identified. Do I place the 53 directly into the query under
criteria or do i need to create some kind of function?
 
If there is a common text between the ID's you can use the wid card (e.g AB1
, AB2 , AB3 etc when the AB is common)

Select * From TableName Where FieldName Like "AB*"

Or if the ID between two numbers

Select * From TableName Where FieldName Between 1 And 54

Or, smaller
Select * From TableName Where FieldName < 54

If it's none of this cases, more I'll need more information on what you are
trying to do
 
Back
Top