Calculated fields

  • Thread starter Thread starter Stig
  • Start date Start date
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
 
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.
 
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]
 
Back
Top