calculate an amount for discount

[Garry]

Hi all

In my report I need to calculate an amount for discount

125 * 0.315 = £ 39.3375

How can I return this value as a negative number that will print as an
accounting
figure e.g (£ 39.3375) showing a minus figure

Also after calculating no matter what I try I sometimes get the amount too
many decimal places
instead of the required two as above. How can I resolve this. Many thanks

 

[fredg]

Hi all

In my report I need to calculate an amount for discount

125 * 0.315 = £ 39.3375

How can I return this value as a negative number that will print as an
accounting
figure e.g (£ 39.3375) showing a minus figure

Also after calculating no matter what I try I sometimes get the amount too
many decimal places
instead of the required two as above. How can I resolve this. Many thanks

What do you wish to show if the amount is 0?
If my memory is correct, one either shows the negative amount with a
minus sign or enclosed in parenthesis. Not both.
Also, you have not been clear as to whether you wish to show just 2
decimals or show 4 decimals.

Set the expression to compute the discount:

= -(125 * 0.315)

On the Control's Format property line, write:

£ #,##.00;(£ #,##.00);£ 0.00

Add 2 more zeros if you do wish to show 4 decimals.

Look up Format + Number and Currency datatype in Access help.

 

[Garry]

Many thanks Fred Just the job

What do you wish to show if the amount is 0?
If my memory is correct, one either shows the negative amount with a
minus sign or enclosed in parenthesis. Not both.
Also, you have not been clear as to whether you wish to show just 2
decimals or show 4 decimals.

Set the expression to compute the discount:

= -(125 * 0.315)

On the Control's Format property line, write:

£ #,##.00;(£ #,##.00);£ 0.00

Add 2 more zeros if you do wish to show 4 decimals.

Look up Format + Number and Currency datatype in Access help.