Decimal places in crosstab report

S

Susy

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?
Thanks,
Susy
 
M

[MVP] S.Clark

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


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
D

Duane Hookom

The value results of a query are variant types. You can wrap the values in
=Val([yourfield])
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

Similar Threads

Access stripping decimal places in query 1
Limiting Decimal Places in a Crosstab Union Query 1
Formatting sums in crosstab? 7
Too many decimal places in Pie Chart 1
Number of decimal places output 8
Decimal places and Date Range in Expression Builder 2
Using the format function for a percent with four decimal places 5
Removing Decimal Places in Query 3

Top