If lastupdate contains a time value then you cannot get equality
For DateTime field:
WHERE ... Format(Lastupdate,"YYYYMMDD")=Format(Date()-30,YYYYMMDD) ...
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244