Between function using DateAdd

losthome

Registered User.
Local time
Today, 13:54
Joined
May 17, 2002
Messages
25
Hi There, I have a query that is for filtering people that their 90 day review is coming up.

Field: nintydayreview: DateAdd("d",83,[EmployeeStartDate])
Criteria: [forms]![frm-90dayreviewtime]![meetingdate]

This only bring up the people exactly 83 days, how do I pick the people from 83 days to 90 days?

Thank you,

Jennifer
 
Field: [EmployeeStartDate]
Criteria: Between DateAdd("d",83,[forms]![frm-90dayreviewtime]![meetingdate]) and DateAdd("d",90,[forms]![frm-90dayreviewtime]![meetingdate])

Possibly you may have to replace comas with semi-colons
 
NinetyDayReview: Between ([EmployeeStartDate] + 83) and ([EmployeeStartDate]+90)
 

Users who are viewing this thread

Back
Top Bottom