SQL Syntax Question - LIKE Operator

[XLGibbs]

Malik,

If you have multiple criteria, it makes sense to use the second table and either do:

Select Sum(Table.Items)
From Table
Where TI.[CriteriaField] in (Select CriteriaColumn FRom CriteraTable)

You can also link using a join

Select Sum(Table.Items)
From Table inner join CriteriaTable on Table.FieldName = CriteriaTable.Criterea

Which would only return the sum of matching rows where the criteria field in Table matches the values in the Criteria table.

You can also use dynamic SQL, but with that many variables and LIKE syntax..it gets "messy"