Decimal places in crosstab report

  • Thread starter Thread starter Susy
  • Start date Start date
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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
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

Limiting Decimal Places in a Crosstab Union Query 1
Access stripping decimal places in query 1
Formatting sums in crosstab? 7
Too many decimal places in Pie Chart 1
How do I add decimals to crosstabs in Access? 3
Export crosstab query to Excel: Row hight and Decimal 6
Decimal places and Date Range in Expression Builder 2
Number of decimal places output 8

Back
Top