Formatting an Expression

S

Shoelaces

I have a query in which I perform an average. The result is returning some
values with 15 decimal places. I can easily change the display options for
the field to limit how many decimal places I display, but the value in the
query is still 15 places.

I am trying to display these values in FP. So, even though I can control
the display within Access, FP is pulling up the 15 decimal places.

Either there is a function in FP to limit this (I have not seen such a
thing) or I want to limit it within Access (which seems to be the most
promising).

So, how can I limit the value stored in the expression? I am using Office
2003.

I appreciate any help that you can offer.
 
S

Shoelaces

Okay, of course right after I post, I came up with a solution. I am not
certain this is the best, but it does work.

INT(average expression)

What if I wanted to display one or two decimal places instead of whole
numbers?
 
Top