Others

Create an Expired Quote Yes/No Field in Microsoft Access

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 868 views

Question details

Create a calculated field that identifies quotes more than three months old and displays the result as True or False.

Create an Expired Quote Yes/No Field in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
A user wants to show whether a quoted price has expired in an Access query, form, or report.
Observed behavior
The expiration result should update based on the quote date and the current date.
Before you start

Identify the table and date field used to record each quote. The example below uses a date field named QuoteDate; replace it with your actual field name.

Solution 1Recommended

Calculate quote expiration in an Access query

Use a calculated query field to evaluate expiration whenever the query runs, without storing a status that can become outdated.

1
Open Query Design

In Access, select Create > Query Design and add the table that contains your quote dates.

2
Add the calculated field

In an empty Field cell in the design grid, enter: Expired: [QuoteDate] < DateAdd("m", -3, Date()). Replace QuoteDate with your date field name.

3
Run and format the result

Select Design > Run to view the results. To display True or False rather than -1 or 0, return to Design View, select the Expired field, open its Property Sheet, and set Format to True/False.

4
Use the query in a form or report

Save the query, then open the form or report in Design View and set its Record Source property to the saved query. Add the Expired field to the form or report and set its control's Format property to True/False if needed.

Calculate quote expiration in an Access query
Missing quote dates: If QuoteDate is blank, the comparison returns Null rather than True or False. Decide how missing dates should be handled before relying on the result.
Free Microsoft Office alternative

Review quote dates in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Move spreadsheet-based quote lists into WPS Spreadsheets to review dates and use formulas; it does not fix or replace Microsoft Access queries.

Review quote dates and calculate expiration in a spreadsheetOpen and edit Microsoft Excel XLSX files for easier migrationUse a familiar interface for everyday spreadsheet workWork with a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access show -1 or 0 instead of True or False?

Access represents True as -1 and False as 0. In the query field's Property Sheet or the form control's properties, set Format to True/False to display the words.

Does a quote expire exactly three months after its date?

The expression uses a less-than comparison, so a quote dated exactly three months before today is not marked expired until the following day.

Why shouldn't I store the expiration status in the table?

The status changes as time passes. A calculated query field evaluates the date against Date() when the query runs, so the stored record does not need to be updated each day.

How can I show the expiration result on an existing form?

Set the form's Record Source property to the saved query, then add the Expired field to the form. Set the control's Format property to True/False if needed.