Format The Output......

[MikeUK]

hi every1
in a table i have 2 values in the 2 fields Weight and Levy. in a query then i create a "Total" field by using the formula below.


Total: [WEIGHT]*[LEVY]

unfortunatly the output of the number is in pence, eg 100 instead of 1.

is there anyway i can format the way the data is displayed in this newly created Total field? a decimal point or a £ i dont mind!

thanx!

 

[Mile-O]

In the query, right click on the field and select Properties - set the format to currency.

 

[MikeUK]

thanx, i did that, but for sum reason the result is incorect!
1 X 1.25 doesnt give £125.00 (doesnt it!?!?!?)




PARCELID WEIGHT LEVY Total
1 1 £1.25 £125.00

any thoughts......

 

[Mile-O]

Total: ([WEIGHT]*[LEVY])/100

 

[MikeUK]

of course, mile to the rescue again!!!

cheers mate

 

[Pat Hartman]

You should NOT have to divide by 100 to get the correct results. There is something wrong with the definition of one or both of the fields involved in the calculation. Don't use a bandaid, solve the problem.

 

[MikeUK]

does any body have the correct solution then??

plz help!!

 

[Pat Hartman]

Look at the definitions of the fields in the table. Look at the data. If you still can't see the error, post your db. Tell us what version it is and make sure it is as small as you can make it.