Access 2002 Queries

[Shabbir]

Hi

I have a query which has three columns A,B, and

Column C is an expression which multiplies column A by Column B and the results come out with figures with multiple decimal places

How can i format the results so that it doesnt show any decimal places

I hope someone understands what it is i am trying to do!

 

[J. Goddard]

Hi -

Try using the format function in the expression for column C:

format([columnA * columnB],"###0").

The exact format you use will depend on size of the number. Note that
this will round the answer up if necessary. If you don't want to round
the answer, use the int function.

You can also set the format using the properties of the column (right
click the column)

HTH

John.

 

[Eugene]

Try right clicking in column C (when the query is in
design view), select Properties and set the format.

Hopefully that helps.

-----Original Message-----
Hi,

I have a query which has three columns A,B, and C

Column C is an expression which multiplies column A by

Column B and the results come out with figures with
multiple decimal places.