Decimal places in crosstab report



Hi, I have a complex crosstab query that output as the
value both dates and numbers. How can I format the numbers
to two decimal places? Currently they're 8 or more places.
I tried formatting the input queries, and tried formatting
the control on the report. Neither work. Any suggestions?

[MVP] S.Clark

In the underlying query or queries see if you can use the Format() function
ahead of time on the data.


Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!

Duane Hookom

The value results of a query are variant types. You can wrap the values in
Then set the format of the text box.

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