When searching a Table [Style].[Type] for specific Records out of 58,000 Records which is more efficient,
"Like (Or) - Not Like <> (And)"?
Or is this efficiency based solely on the number of parameters in Criteria?
When searching a Table [Style].[Type] for specific Records out of 58,000 Records which is more efficient,
"Like (Or) - Not Like <> (And)"?
Or is this efficiency based solely on the number of parameters in Criteria?
Please give a sample of your proposed statement using your data.
In Query Design
[Style].[Type]
Criteria = "JKit" Or "LGD" Or "NDL" Or "Sales"
Or
<> "GemPack" And <> "Plating" And <> "TU" And <> "Engraving" And <> "NJI"
You are using = and <>
Here are some ways of accomplishing
[Style].[Type]
Criteria = "JKit" Or "LGD" Or "NDL" Or "Sales"
1)
Criteria = "JKit" Or
Criteria = "LGD" Or
Criteria = "NDL" Or
Criteria = "Sales"
2)
Criteria IN( "JKit" , "LGD", "NDL", "Sales")
For <> "GemPack" And <> "Plating" And <> "TU" And <> "Engraving" And <> "NJI"
I would try (untested) -- you should google de Morgans Law
Criteria Not IN ("GemPack" , "Plating" , "TU" , "Engraving" , "NJI" )
Either way they both work. My question was " is one more efficient than the other?"
Thanks Randy!