Create an Expired Quote Yes/No Field in Microsoft Access
Question details
Create a calculated field that identifies quotes more than three months old and displays the result as True or False.

- 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.
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.
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.
In Access, select Create > Query Design and add the table that contains your quote dates.
In an empty Field cell in the design grid, enter: Expired: [QuoteDate] < DateAdd("m", -3, Date()). Replace QuoteDate with your date field name.
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.
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.

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.

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.




