How can I format numbers in an Access union query?

[MJS]

I have created a union query from 2 crosstabs. The numbers in the crosstab
are formatted as standard, with 0 decimals. That formatting is not carrying
through to the results of the union query.

 

[Douglas J Steele]

Use the Format function on both halves of the Union statement.