Calculations

J

josh_hat

Registered User.

Local time

Today, 18:55

Joined

Jun 12, 2003

Messages

13

• Jun 13, 2003

• #1

I am trying to calculate a due date for my equipment. I am creating a table right now and I have a field that is the last date of certification. I also have a field that has the number of months till the equipment needs recertification. I am having trouble getting the field for the due date to calculate.

I am not even sure if it can be done while in the table design.

Thanks.

 

dcx693

Registered User.

Local time

Today, 18:55

Joined

Apr 30, 2003

Messages

3,263

• Jun 13, 2003

• #2

Before everyone in this forum scolds you for attempting to store calculated data in a table, let me say that you are best off not even attempting to do this, but to calculate your due dates using a calculated field in a query. The DateAdd function is great for those calculations.

 

J

josh_hat

Registered User.

Local time

Today, 18:55

Joined

Jun 12, 2003

Messages

13

• Jun 13, 2003

• #3

When I use the DateADD funciton, I put "m" for the interval value.
Then when I try to view outside the design view it as to set a parameter value. What does that mean.

Thanks again for your help.

 

dcx693

Registered User.

Local time

Today, 18:55

Joined

Apr 30, 2003

Messages

3,263

• Jun 13, 2003

• #4

Please post your DateAdd function here and we'll take a look at it.