Expiry Dat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello Everyone
I am a new user...I want to set expiry date in a field...I have one field
that show the filing date and i want to make another field that show
automatic expiry date after one year...

any body has idea
 
If the expiry date is always 1 year after the filing date, why bother
storing it in the table?

Create a query, and add a computed field to it that calculates ExpiryDt:
DateAdd("y", 1, [FilingDt])

Use the query wherever you would otherwise have used the table.
 
Back
Top