Future date from last entry.

[Guest]

I am running a small data base at work to capture information on verious
items for my staff. Our company require staff to atend a medical survey every
two years. For my area i have a slot to send two persons on a friday only. I
would like to run a report in the begining of the month showing all the
persons due for the survey in this month. This means that it will be all
staff attended two years ago. If posible move the date for the friday of the
week. Should I run a query or would it be posible to perform this direct from
my table in reporting. The medical vissits do have different names but i am
only interested in the medical survey.
I am fairly new with access and would appreciate any help.

 

[Guest]

Hi CR Nigeria,

You definitely want to run a query, something like

select StaffName, max([StaffSurveyDate]) from StaffSurveyTable where
max([StaffSurveyDate]) < dateadd("yyyy",-2, DATEONFRIDAY)
group by StaffName

Hope that helps.

Damian.