Limiting Decimal Places in a Crosstab Union Query

  • Thread starter Thread starter Susy
  • Start date Start date
S

Susy

I have a complex crosstab query created from a union of
four subqueries.

qryGetMins (numbers)
qryGetMinDate (date)
qryGetMax (numbers)
qryGetMaxDate (date)

qryMax&Min (union query)

Crosstab_Max&Min
Item Number Date Number Date Number Date


My numbers go to 8 decimal places and on the report I want
to limit them to 2. I tried formatting the "value" control
on the report but it doesn't affect the display. I tried
formatting the subqueries but that doesn't affect the
report either. Any suggestions?

Thanks.
 
Susy said:
I have a complex crosstab query created from a union of
four subqueries.

qryGetMins (numbers)
qryGetMinDate (date)
qryGetMax (numbers)
qryGetMaxDate (date)

qryMax&Min (union query)

Crosstab_Max&Min
Item Number Date Number Date Number Date


My numbers go to 8 decimal places and on the report I want
to limit them to 2. I tried formatting the "value" control
on the report but it doesn't affect the display. I tried
formatting the subqueries but that doesn't affect the
report either. Any suggestions?
Click to expand...

You set the report control's Decimal Places property to 2 (under the
Format tab of the control's Properties dialog box)?
 
Back
Top