Others

Format and Concatenate Percentage Fields in a Microsoft Access Query

Nimra MalikNimra Malik Nov 20, 2026 869 views

Question details

The user needs to combine two percentage fields in a Microsoft Access query while preserving percentage formatting.

Format and Concatenate Percentage Fields in a Microsoft Access Query
Product
Microsoft Access
Device & OS
not provided
Scenario
Create a calculated query field that displays a low and high percentage separated by a hyphen.
Observed behavior
Values displayed as 17% and 25% appear as decimal fractions such as .17 and .25 when concatenated.
Before you start

Open the Access database and identify the two numeric fields you want to combine. Confirm that their stored values are decimal fractions, such as 0.17 for 17%.

Solution 1Recommended

Format each percentage before concatenating the fields

Use a calculated field in Query Design to convert each decimal value to percentage-formatted text before joining them.

1
Open the query in Design View

In the Navigation Pane, right-click the query and select Design View, or create a query using Create > Query Design.

2
Add a calculated field

In a blank Field cell in the query design grid, enter: BothPercents: Format([ContentLowPercent], "Percent") & "-" & Format([ContentHighPercent], "Percent"). Replace the field names with your own if needed.

3
Run the query

Select Run on the Query Design ribbon and check the BothPercents column for the formatted range.

Format each percentage before concatenating the fields
Decimal places may vary: The Percent format uses system formatting settings and may show decimal places. To display whole percentages, use "0%" instead of "Percent" in both Format calls.
Free Microsoft Office alternative

Work with percentage ranges in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Export Access query results to Excel when you want to continue working with the data in WPS Spreadsheets; WPS does not fix or replace Microsoft Access queries.

Format and combine percentage values in spreadsheetsCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access show .17 instead of 17% when I concatenate a field?

Access stores 17% as the numeric value 0.17. Concatenation converts the value to text, so apply Format([FieldName], "Percent") before joining it to other text.

How can I show the range without decimal places?

In the query design grid, use BothPercents: Format([ContentLowPercent], "0%") & "-" & Format([ContentHighPercent], "0%"). This displays values such as 0.17 and 0.25 as 17%-25%.

Can I use different field names in the expression?

Yes. Replace [ContentLowPercent] and [ContentHighPercent] in the calculated Field cell with the names of your own query fields, keeping the brackets around each name.

Can WPS Office edit my Access query directly?

WPS Office is not a replacement for Microsoft Access query design. You can export query results from Access to an Excel file and open that file in WPS Spreadsheets.