Microsoft Access Database Query - Help

  [DELETED] 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.

  [DELETED] 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

Xiaomi Mi 8 Review

Adobe confirms it’s working on a full Photoshop for the iPad

Apple announces new MacBook Pros for 2018

Qu’est-ce qu’Amazon Prime ?