Due date query

  • Thread starter Thread starter Arunoday
  • Start date Start date
A

Arunoday

I need to calculate the due date in my database.. like i have three fields
like - Issuedate, LIfe of Item and Nest due date...
now when i m entering the issuedate and the life of the product, the next
due date should be automatically counted.......
pls guide me...
(ex-Issuedate - 01/01/2008, LIfe of Item - 12 months, Nest due date - ?)
(LIfe of item will be counted in months...)
 
I need to calculate the due date in my database.. like i have three fields
like - Issuedate, LIfe of Item and Nest due date...
now when i m entering the issuedate and the life of the product, the next
due date should be automatically counted.......
pls guide me...
(ex-Issuedate - 01/01/2008, LIfe of Item - 12 months, Nest due date - ?)
(LIfe of item will be counted in months...)
Click to expand...

Only two of these fields should EXIST in your table, since the third can be
derived from the other two.

I'd remove the DueDate. Calculate it in a Query using

DueDate: DateAdd("m", [Life of Item], [Issuedate])

This calculated field can be used in any way that a stored field can be used
*except* that it cannot be updated (since if it were updated it would be
WRONG).

You can use the Query as the recordsource for a form or report, there's no
need to store the duedate.

John W. Vinson [MVP]
 
Back
Top