Thread
:
simple query not working-urgent please
View Single Post
#
1
September 27th, 2004, 02:10 PM
external usenet poster
Posts: n/a
simple query not working-urgent please
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