calculate % in a report

[Lightlancer]

hi all,

i a report in access 2007 i have 3 fields,

field 1 = Price
field 2 = discount
field 3 = total

to get total working i did have =([Price]*20)
then the price will be * 20 in total, now the field total
must also calculate the discount, in that field there is 0% till 100% how can i calculate the discount over the Price and get the total in the field total?

greetz

lightlancer

 

[PHV]

Something like this ?
=[Price]*20*(1-[Discount])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lightlancer]

field give #error
with this code....

 

[ProgramError]

=(price/100)*20
means 20 percent of price so..

=(total/100)*discount
will give you the discount percentage of the total.


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[PHV]

field give #error
Follow the expression builder to verify the correct spelling.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lightlancer]

solved, used ProgramError his method.

Thanks for the help