Date Calculation

[Lazor78]

Hi

I have a simple DB with 7 forms.

In 4 of hte forms i would like to be able to enter a date in a field and then a date 1 month from that be entered in the field below it. There is a column for it in the table alreaady.

I have created the expression [Date Sent]+31 as the default value and it works for hte 1st record but then only populates every record (300+) with that date.

Is there a simple fix?

Thanks

[alansidman]

Here is an example attached using the dateadd function

[Lazor78]

Thats great, thanks a lot.

[Lazor78]

Hi

Will this automatically update in the table, so that when i run a query it will pull through these dates?

Thanks

[alansidman]

No. Calculations are not to be stored in tables. If you want the calculation displayed as part of a query, then use the dateadd function in a new field in the query as an expression and it will always be accurate based upon the date in the first field.

Look here on how to put it in a query.

http://www.techonthenet.com/access/f...te/dateadd.php