Round Dbl to 2 dec pt

[Guest]

Hi,
I am using Access 2000. I have a table with a number column with field size
set to double. I'd like to create a query that returns this column rounded
to two decimal places. Can anyone tell me if there is a built-in Access
function I can use to do this?

Thanks,
Paul

 

[Guest]

There's two types of rounding you can perform: "banker's rounding" and just
regular rounding. I prefer the normal rounding (where .5 and higher always
rounds up).

Regular Rounding: Use Format (e.g., Format([number], "0.00"))
Banker's Rounding: Use Round (e.g., Round([number], 2))

David Atkins, MCP

 

[Guest]

Thanks David...that worked great!

Paul

There's two types of rounding you can perform: "banker's rounding" and just
regular rounding. I prefer the normal rounding (where .5 and higher always
rounds up).

Regular Rounding: Use Format (e.g., Format([number], "0.00"))
Banker's Rounding: Use Round (e.g., Round([number], 2))

David Atkins, MCP

Hi,
I am using Access 2000. I have a table with a number column with field size
set to double. I'd like to create a query that returns this column rounded
to two decimal places. Can anyone tell me if there is a built-in Access
function I can use to do this?

Thanks,
Paul