FIXED worksheet function in MS ACCESS 2000

[ctaylor]

In MS Excel there is something called a FIXED function where you enter in a variable containing a double precision floating point number and an agrument that states the number of decimal point precision to display.

Syntax looks like this: FIXED(A1,2)

and returns a value like #.##
where the # represents a digit character.

My question is whether there is a way to force a query to force the display of a number to have a set decimal precision within MS Access.

I know how to format data within a report or form, but I want to format data at the query level.

[ctaylor]

I figured it out - no need for further follow up.

The FORMAT function works

Syntax is like this

FORMAT(#######.#########, "0.00") where #######.######### is a number or expression.

[thonymanongas]

Thanks a lot, this thread saves me lots of trouble.

--Anthony