Count items over 30 days old

[lmossolle]

I have a date field "daterecieved" i would like to query for items over 30
days old where a completed field is null. Please assist.

Thanks

 

[Jerry Whittle]

SELECT *
FROM YourTable
WHERE daterecieved < Date() – 30
AND completed Is Null ;

Or in the query design view put the following in the criteria under the
daterecieved field:
< Date() – 30

And Null in the criteria under the completed field.

If Access puts double quotes " around either criteria, something is wrong.