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.
 
Back
Top