Others

How to Display Quarter and Year Names in an Access Report

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to display dynamic data, specifically quarter and year names alongside text, in an Access report, but the expressions are rendering as literal text.

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing a report in Microsoft Access and configuring control sources to display dynamic field data seamlessly integrated with static text.
Observed behavior: The report controls are displaying the exact expression text entered by the user rather than evaluating it to show the actual quarter and year values from the underlying data source.

Before you start

Ensure your Access database is open in Design View and that the record source connected to your report actually contains the quarter and year fields you intend to display.

Solution 1Recommended

Use the Ampersand Operator to Concatenate Text and Fields

Combine literal text strings with dynamic field variables using the ampersand (&) operator in the Control Source property of a text box.

In Microsoft Access, standard label controls can only display static text. To evaluate formulas or combine text with database fields, you must use a Text Box control and enter your expression in its Control Source property. The ampersand (&) is required to successfully stitch text strings and dynamic field variables together.

Open Report in Design View

Right-click your report in the Access Navigation Pane and select Design View.

Insert a Text Box

From the Report Design tools at the top, select the Text Box control and click on your report to place it. Do not use a Label control, as it cannot process expressions.

Access the Property Sheet

Select the newly inserted text box and press F4 to open the Property Sheet pane on the right side of the screen.

Enter the Expression

Navigate to the Data tab in the Property Sheet. In the Control Source property, type an equals sign followed by your expression. For example, enter: ="Total for " & [saleQuarter] or ="Total for " & [saleYear].

Verify Field Names

Ensure that the text inside the square brackets (like [saleQuarter]) exactly matches the field names in your report's underlying record source.

Preview the Report

Switch to Print Preview or Report View to confirm that the text box now dynamically pulls in the correct quarter and year names instead of showing the literal formula.

Use Quotes for Static Text: Always enclose your static text elements in double quotation marks and leave a space inside the quotes if you want separation between the text and the dynamic field value.

Free Microsoft Office alternative

Looking for a Free, Lightweight Office Suite?

While WPS Office does not include a direct database alternative to Microsoft Access, it is an exceptionally powerful suite for your everyday document, spreadsheet, and presentation needs. Switch to WPS Office to enjoy seamless file compatibility and a rich feature set without expensive subscriptions.

1. Download the Installer: Visit the official WPS Office website and download the free version for your specific operating system.
2. Install WPS Office: Run the downloaded installer and follow the on-screen prompts to complete the lightweight installation.
3. Open Your Office Files: Launch WPS Office and open your existing Word, Excel, or PowerPoint files instantly with zero formatting loss.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Free, lightweight, and fast installation that doesn't slow down your device.Integrated PDF toolkit for easy editing, merging, and signing of documents.Familiar tabbed interface making it incredibly easy for Microsoft Office users to adapt.

Frequently Asked Questions

Why is my Access expression displaying exactly as I typed it?

If your expression appears as literal text (e.g., you see ="Total for " & [saleQuarter] on the printed report), you likely typed it into a standard Label control or typed it directly into the text box instead of the Control Source property. Labels cannot calculate formulas. Delete the label, insert a Text Box, and put the formula in the Control Source property of the Property Sheet.

What does the ampersand (&) do in an Access report expression?

The ampersand (&) acts as a concatenation operator. It instructs Access to combine literal text strings (which are enclosed in quotes) and dynamic data fields (enclosed in square brackets) into one single, continuous string of text.

Can I display both the quarter and the year in the same text box?

Yes. You can chain multiple text strings and fields together using multiple ampersands. For example, to show both, you would enter: ="Total for Q" & [saleQuarter] & " of " & [saleYear].

Why am I getting a #Name? error in my text box?

The #Name? error typically occurs if the field name inside your square brackets does not exactly match a field in the report's record source, or if you misspelled the field name in your expression.

Office Quick Solutions