By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,639 Members | 1,988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,639 IT Pros & Developers. It's quick & easy.

setting up an automatic expired status in the field

P: 1
hey there! im new in ms access. can you help me with my access data and i want automatically put a remark "expired" text in the (status field) after 5 years from the (date issued field). how can i do that? thank you in advance ^^
Feb 14 '19 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,282
Jacky cole,

Welcome to Bytes!

Do you want the database to check your data every time the DB is opened or do you want to accomplish this as a one-time exercise that can be executed whenever you want? In general, the method is the same, it just depends on the nature of your question. Are you concerned with the automatic aspect or the updating aspect.

Thanks.
Feb 14 '19 #2

Post your reply

Sign in to post your reply or Sign up for a free account.