Calculating Exp. Dates in Microsoft Access

5 pts.
Tags:
Access Database
Microsoft Access
I am creating a database for my boss that houses realty leases and I need to have a calculated field that will let me know 60 days before the lease expiration date.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you are using Access 2010 (or above) you can add calculated fields to tables.

How?

Add a calculated field to a table

But, personally, I don’t think it is a good idea to store calculated fields.  If you are on an older version or do not want to store the calculations in the table, you may create a query and add the calculated field to the query.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MarvinM80

    Hi LaceyRae,

    I understand the need, but I must ask...

    WHERE do you want this calculated field?

    In the answer from Carlos, he assumes that you want it in a table. That's a valid assumption, but maybe you want this calculated field to show on a form or report.

    This, of course, depends on how your boss wants to use this alert field. Does he expect to get weekly, printed reports, in which the Under 60's are identified for lease negotiations? Does he want to work on a screen in which the Under 60's are flagged for his attention?

    There are ways to accomplish this no matter which way you want to go. We just need to know what will work best for your boss so that we can guide you the right way.

    Regards,

    Marvin M80

     

    50 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following