Need Help Calcuating a Date (Starting Date + Number of Days Between)

[Lidsavr]

I am running Microsoft Access 2007 SP1.

I have a table (called CAL_INFO) and form (CAL_INFO_FORM) setup in a simple Access database that tracks equipment in my company. One of the fields in the form has a date that the equipment was last checked for accuracy. I call this field "DATE_LAST_CAL". This field is a date field (mm/dd/yyyy)

Another record has the amount of days before the equipment needs to be checked again. I call this field "CAL_CYCLE." This field is a number field. In this field, most days = 365 (1 year), but there are a few that are 182 (6 months) and some that are 1095 (three years).

Last, I have a third field called "CAL_NEXT_DUE". The field is formatted as a date field (mm/dd/yyyy). In this field I have tried to build a formula using the expression builder to get the DATE_LAST_CAL and add the CAL_CYCLE to it to get the CAL_NEXT_DUE date. The expression I have built in the form in the CAL_NEXT_DUE properties is:

=[CAL_INFO]![DATE_LAST_CAL] + [CAL_INFO]![CAL+CYCLE]

What I get back is this error: #NAME?

I used to do minor databases for my own use using Access 2000, and haven't done this for a long time, so any help is very much appreciated.

 

[alansidman]

=[CAL_INFO]![DATE_LAST_CAL] + [CAL_INFO]![CAL+CYCLE]


Your second field name you listed as [CAL_CYCLE]

Is your formula correct or is this just a typo.

 

[Lidsavr]

It is a typo! But I was just coming back to say that I figured it out. Since I was in the form, I ended up using:

=[LAST_CAL_DATE]+[CAL_CYCLE]

and it worked. I just needed to use the form fields only, instead of the tables' fields.

Thanks!