Limiting Decimal Places in a Crosstab Union Query

[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.

 

[MGFoster]

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?

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