limiting decmial places

[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

 

[Timothy C. Doherty]

Round(YourField,1)

....where "YourField" is the name of the field you wish to round.

 

[Ken Allen]

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.

 

[KW]

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.

 

[matt shudy]

Thanks guys!

Matt