Format and Concatenate Percentage Fields in a Microsoft Access Query
Question details
The user needs to combine two percentage fields in a Microsoft Access query while preserving percentage formatting.

- 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.
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%.
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.
In the Navigation Pane, right-click the query and select Design View, or create a query using Create > Query Design.
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.
Select Run on the Query Design ribbon and check the BothPercents column for the formatted range.

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.

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.




