"Not Like"

S

SthOzNewbie

I have a totals query which looks for records that contain an "S" in a
particular field via a WHERE clause -

WHERE (((tblSalesData.InvDte)>DateSerial(Year(Date()),Month(Date())-3,1))
AND ((tblSalesData.ShipFrWh) Like "S*"))

Now I would like to create a totals query which look for records that do not
contain an "S". What would the correct sysntax for that statement be ?

TIA

IK
 
K

KARL DEWEY

Try this --
WHERE (((tblSalesData.InvDte)>DateSerial(Year(Date()),Month(Date())-3,1))
AND ((tblSalesData.ShipFrWh) Not Like "S*"))
 
S

SthOzNewbie

Thanks Karl,

I was so sure I had tried that already and got an error. Must have been a
typo on my part.

Regards,

IK
 
Top