Microsoft Access Database Query - Help

  ihbuk1 14:37 06 Feb 2006
Locked

I have an Access Database (2000) where I have a date sent field and a date returned field. If the date returned field is empty, I want to run a report that shows empty fields one month after the date entered in the date sent date. Any help would be most appreciated, thanks.

  Access genu 16:06 06 Feb 2006

SELECT * FROM MyTable WHERE isnull(DateReturned) AND DateSent < dateadd(Date,"mm",-1)

Will select all records where there is no return date and it has been out for greater than 1 month.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Why this awful City of Los Angeles job ad for a graphic designer is actually brilliant

iMac Pro review

Les meilleures prises CPL (2018)