limiting decmial places

  • Thread starter Thread starter matt shudy
  • Start date Start date
M

matt shudy

Hi,

Is there a way to limit the amount of decmial places
returned by a query? I have a query that divides two
cells from my table, but returns a 7.3435.... is there a
way to limit it to 7.3?

Thanks,

Matt
 
Round(YourField,1)

....where "YourField" is the name of the field you wish to round.
 
By right clicking on the calculated field, a drop-down
menu should show properties. There is a list of
formatting options. "Standard" seems like a good choice,
followed on the next line of the properties list with the
number of decimal places.
 
If your query was developed in the query builder and is
executed from there, you can set the Format and Decimal
Places Properties for the field in the query builder.
 
Back
Top