424,279 Members | 1,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,279 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 ^^
5 Days Ago #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 2,886
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.
5 Days Ago #2

Post your reply

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