Calculated fields

S

Stig

How do I get a field to calculate a date 60 months in advance of another
date field.
I can do it in Excel but not in Access.
Thanks
Dave
 
R

Rick Brandt

Stig said:
How do I get a field to calculate a date 60 months in advance of
another date field.
I can do it in Excel but not in Access.
Thanks
Dave
Click to expand...

That's because you don't do calculations in tables. Use a query, form, or
report and put the calculation there.
 
J

John Vinson

How do I get a field to calculate a date 60 months in advance of another
date field.
I can do it in Excel but not in Access.
Click to expand...

Use a Query; in a vacant Field cell type

FutureDate: DateAdd("m", 60, [datefield])

and then use this Query as the recordsource for a form or report.

John W. Vinson[MVP]
 
Top