Calculation Problem

[djwasim]

i am facing problem in calculating two fields i.e

there are Three fields in my mdb named Quantity, Price, Value

In quantity field the value is " -70 " and in Price field the value is 50
but when i multiply the quantity with price the result is "0" instead of "-3500"

For example........

Quantity--Price--Value
"-70"-------50"---"0"

Instead of..........


Quantity-- Price--Value
"-70"------"50"--"-3500"

plz help me.

wasim shahzad
pakistan

 

[namliam]

Are both fields actual number fields, instead of text fields?

 

[djwasim]

yes both are actual number fields

 

[namliam]

What formula are you using? I presume: Quantity * Price

I also presume your "value" is a calculated field in a query...

 

[djwasim]

i am using the formula as

=Nz([Quantity]*[Price],0)

But only those values which are not a minus value(-70) shows the result for example

Quantity--Price--Value
"-70"-------50"---"0"
"10"-------"50"---"500"

 

[namliam]

how about not using the NZ?

[Quantity]*[Price]

 

[djwasim]

but there is the same problem by using
[Quantity]*[Price]

 

[namliam]

Then I am sorry I am stuck...

 

[djwasim]

ohh no yar
any one plz help me...........

 

[hiền muội]

Value: IIf([quantity]<0 Or [Price]<0,0,[quantity]*[Price])

 

[namliam]

Oh my, I totaly read the question wrong!! I read it the wrong way around...

 

[djwasim]

Thanks Buddy
I have got it