Calculated fields

[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

 

[Rick Brandt]

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

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

 

[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.

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]