G
Guest
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.
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.