Microsoft Access Database Query - Help

  ihbuk1 14:37 06 Feb 06
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 06

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced