"Not Like"

[Guest]

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

 

[Guest]

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

 

[Guest]

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