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

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?