limiting decimals in query results

  • Thread starter Thread starter IR Analyst
  • Start date Start date
I

IR Analyst

I have a query that gives me the correct average dollar amount, but it gives
me way too many decimal places. Just to make the query look nice and neat, I
would like like to limit the number of decimals. So instead of seeing
2802.6911236454 as the AvgofSumofAmount, I would like the query to give me
2802.69. Can anyone help me? Thanks in advance!
 
IR Analyst said:
I have a query that gives me the correct average dollar amount, but it gives
me way too many decimal places. Just to make the query look nice and neat, I
would like like to limit the number of decimals. So instead of seeing
2802.6911236454 as the AvgofSumofAmount, I would like the query to give me
2802.69.
Click to expand...

You should not care what the value looks like in the query's
datasheet view. Setting the Format property of the
form/report text box that displaye the value is a more
appropriate way to do things.

If you really feel the urge to format the query's datasheet,
you can set the field's Format property to Currrency or 0.00
 
Back
Top