Bob H wrote:
I have a tools database with LastTestDate and NextTestDate fields, which
is conditionally formatted for approaching NextTestDate.
What I want to do now, is to run a query or report which tells me which
items are out of date.
I have a query which give me the NextTestDate:
NextTestDate: DateAdd([PeriodTypeID],[Freq],[LastTestDate])
So if the NextTestDate is, say today, then I would like to be able to
run a query which will sort out the items which are either out of date
or will be very soon.
Thanks
Just compare NextTestDate to the current date, which is Date(), then return
an appropriate message or just filter.
Out of date: NextTestDateDate()
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1