-----Original Message-----
SELECT Sum([Sales temp].Sales) AS Sales, Date()-1
FROM [Sales temp]
HAVING ([Sales temp]![item] Not in
("25773621","afy04890));
It gives me a "type mismatch error"
Thanks
.
If you copied the SQL exactly then your problem is a
missing quote in the IN clause. If that's not the problem,
then you need to look at your Item field and make sure its
a text field.
Scott
|