IIf and sum

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hello,

In my database I have a continuous form that I use for price calculation. In
a combobox I choose an article number so several data are displayed
afterwards (price, volume, ..). In an unbouded text label I have to fill in
the number of that article needed. So at the end I get a list of articles
composing my product.
For each article there is also a product code (R, V, P) that determines the
VAT percentage. In each "row" of my form I have three text fields (depending
of the product code) in which I calculate the result of article price*number
of articles. I use the following code:
"=IIf([letter]="R";[number1]*[price1];"0")". This works fine but when I try
to get a sum of all the results in the R-column I always get a #Name error.
I tried with =Sum([result1]) and several others but it won't work.

Could someone help me out here?

Thanks

Chris
 
Chris,
Repeat the entire calculation:

=Sum(IIf([letter]="R";[number1]*[price1];0))

Note: there are no quotes around the zero. It's a number not text.
 
Back
Top