Column Autofill

[senkurion]

Hello,

One of the column in my database is "Account opend on" based on the date of
this column I want Acees to autofill other 4 columns , for example, if the
date in column "Äccount Opened on" is 03/27/06 ( or any other dates in
2006) then other 4 column should autofill thensleves 01/01/07, 01/01/08,
01/01/09, 01/01/10 respectively.

If possible I would like to do by putting an expresseion in control source.

Thank you

 

[John Spencer]

Use the following expressions for the other columns.

=DateSerial(Year([Account Opened On]) +1,1,1)
=DateSerial(Year([Account Opened On]) +2,1,1)
=DateSerial(Year([Account Opened On]) +3,1,1)
=DateSerial(Year([Account Opened On]) +4,1,1)
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[senkurion]

Thank you very much

Use the following expressions for the other columns.

=DateSerial(Year([Account Opened On]) +1,1,1)
=DateSerial(Year([Account Opened On]) +2,1,1)
=DateSerial(Year([Account Opened On]) +3,1,1)
=DateSerial(Year([Account Opened On]) +4,1,1)
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Hello,

One of the column in my database is "Account opend on" based on the date
of
this column I want Acees to autofill other 4 columns , for example, if
the
date in column "Äccount Opened on" is 03/27/06 ( or any other dates in
2006) then other 4 column should autofill thensleves 01/01/07, 01/01/08,
01/01/09, 01/01/10 respectively.

If possible I would like to do by putting an expresseion in control
source.

Thank you