Look up the DateAdd function:
? DateAdd("m",4,Date)
5/25/2006
Tobi
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of luvmymelody
Sent: Wednesday, January 25, 2006 11:51 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Show Emp. anniv. date a specified time away.
Hey all,
I am trying to create a create a query to report a specified time like
a week or a month from an employee's anniv. date. I have tried all
kinds of datediff and others but nothing is giving me a correct
answer. Is there a way of doing this?
Jim Wagner
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
