Correct Format For Formula

[alex]

I have a field name “Pricing†with records that look like this 45.000000 but
I want to be able to see this using a query where I want the result to be
45.00 (just two decimal places). I want to be able to use this formula to
achieve this DCount («expr», «domain», «criteria»). Can anyone tell me what
information I need to plug into this formula to get the answer that I want???
I know there is another way of changing the format of the “Pricing†field to
show numbers with only two decimal places but this is not an option for me
because the “Pricing†field is coming from a table which is not editable in
anyway (I have restricted access).

 

[KARL DEWEY]

I do not understand the problem as DCount is counting so the number of
decimal places of what you are counting does not matter.