Calculate date based on other table

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

Below are my 2 tables:-

Table1
ItemID (primary key)
Days

Table 2
Serial number(primary key)
ItemID
dateExpired

I need the dateExpired to be auto calculated when I enter the ItemID. The
dateExpired is today's date + the days in the table 1...May I know the way?
 
It would be a good idea to create an index for the ItemID field in Table 2

You did not say whether there is a form involved of if you are doing
recordset processing or if this is being done in a query. Where you are
doing this will determine how you do this.

Post some additional detail, please.
 
Back
Top