Expiry Dat

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Microsoft Access Calculated Field - Expiry Date 0
expiry date e.g mm/yyyy 1
If Statements in Access 9
Conditional Formatting of date 1
Conditional Formatting due dates 8
DateAdd for expiry and reminder dates 1
how to find date between two date in query 3
Non-Expiring Data Sim Card? 4

Top