It is text and there are quotes in the in clause!!!
-----Original Message-----

-----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
.