Number formats in a UNION query...

[MSherfey]

I am having a problem formatting some numbers in a UNION query.

I have two simple queries which return basic scores and their average for a specific period. I have each query rounds the averages so I don't get any decimals (EX 9.3333=9). When I use a UNION query to get the two separate queries together, it seems to be ignoring the formatting of the original queries and shows the decimal numbers (EX 9.3333).

How do I format the UNION query to retain the rounded number (on export as well)?

 

[boblarson]

Why not format either in the Union Query or use another query on top of the Union one to format. If this is for a report, don't bother formatting because you'll have to do it at the report level anyway.

 

[MSherfey]

I don't know how to format the union query I guess. I went ahead and created a simple query and used the union as a sub-query within it. Simply formatted the parent query and all is well. I wonder if that is the simplest method.