How can I format numbers in an Access union query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use the Format function on both halves of the Union statement.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UNION QUERY.. 3
Union query 5
Union Query 4
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
No Duplication or Data Suppression 3
union queries - with tables containing fields with attachments 2
Query is too complex 5
UNION OF SELECTED TABLES ONLY. 9

Back
Top