Here's the function you'll need:
dateadd("m",3,<your date field>)
if you use -3 in the second parm, it will subtract 3 months.
You can use it in code or in an update query.
Hope it helps!
LaDeana
-------------- Original message --------------
From: "mudrobin" <[EMAIL PROTECTED]>
> I am currently working on a database for work that will print out all
> required parameters for a septic permit. What I am wanting to do is
> take a date field, add 3 months to that date and store it into a field
> in the necessary field in the table.
>
> I am an intermediate user of Access and am very green still to the VBA
> side of things. Could anyone please help me a bit with this. This is
> the last obstacle I have before I am able to do the beta testing on
> the database and I have 8 employees and 2 supervisors who would love
> to get their hands on this.
>
> Thanks in advance
> Mike Adams
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> 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/
