SQL query output has missing decimal for "integer"

[skydivetom]

Hello,



I have the following VBA SQL query:

                    strSQL = "SELECT Q100_Scoring_Input.TIER_1_ID_H, Q100_Scoring_Input.HYPOTHESES_H, " & _
                             "ROUND(Avg(Q100_Scoring_Input.[" & strModel & "_SCORE]), 1) AS [AVG_" & strModel & "_SCORE] " & _
                             "FROM Q100_Scoring_Input " & _
                             "GROUP BY Q100_Scoring_Input.TIER_1_ID_H, Q100_Scoring_Input.HYPOTHESES_H " & _
                             "ORDER BY ROUND(Avg(Q100_Scoring_Input.[" & strModel & "_SCORE]), 1) DESC;"

The output currently appears as follows:

5.7
5.2
5
4.8
4.2
4

However, I need all values to consistently display with one decimal place, like this:

5.7
5.2
5.0
4.8
4.2
4.0

I have attempted various formatting options. In some cases, integers were correctly displayed as "5.0" and "4.0," but this changed the data type to text (causing left-alignment in the query output).

How can I ensure the output remains numeric while consistently displaying one decimal place, including for whole numbers?

Thanks in advance for your help!

[jojowhite]

can you use the Format "0.0"

[skydivetom]

I tried that... output was 'text'.

[pbaldy]

I would probably format it in the form or report the query is being used for.

[jojowhite]

where are you ouputting it? report/form?
if on those two you can control the Alignment of
that column (textbox) on design view (Text Align property).

[Gustav]

You must format it in the form or report the query is being used for.

[NoellaG]

You never show data in tables or query results to the user, you use forms or reports for this, so there is little point doing formatting in a query, is there?

[skydivetom]

No feasible solution provided... closing thread.