Hi,

I'm using FP2003 / Access 2003.

I have created a form using DRW that allows a user to input records into the
Access DB. I want to take a date they entered, calculate a future date, and
put this in a different field in the Access DB.

Any suggestions?

Thanks,
John

Re: DRW and Date Calculations by John

John
Fri May 28 12:21:19 CDT 2004

Found an easy solution.

I just set the default of the field to:

<%=Dateadd("yyyy",1,Date)%>

which give me a date one year from when they enter the record.

"John" <xxxjohnzzz@patmedia.net> wrote in message
news:eWEKDhMREHA.3728@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I'm using FP2003 / Access 2003.
>
> I have created a form using DRW that allows a user to input records into
the
> Access DB. I want to take a date they entered, calculate a future date,
and
> put this in a different field in the Access DB.
>
> Any suggestions?
>
> Thanks,
> John
>
>