percentages in ms access 1

[kpryan]

Hi,
I want to convert $0.00 to percent on a form please

Thanks,

Ken

 

[PHV]

It's simply a Format issue, isn't it ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kpryan]

Basically I have 2 currency fields that subtract into a field with the %format. This does not give a correct interpertaion of the % of the difference between the 2 currency fields.

 

[PHV]

Any chance you could post the expression ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kpryan]

The code is as follows.

In the lost focus event on the form;

profit = nz([gross])-nz([nett])

the 'profit' is the % field
Gross & Nett are currency felds.
I just want the result in the 'profit' field to show the correct percentage.
or is there another way??
Hope this makes sense

Ken

 

[PHV]

You wanted something like this ?
profit = (Nz([gross])-Nz([nett]))/Nz([gross])
or this ?
profit = (Nz([gross])-Nz([nett]))/Nz([nett])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kpryan]

To PHV,
Do appreciate your help. It worked great

Ken