Dsum trouble

[krishnanhemanth]

HI

Iam using this code to get a value

=IIf(IsNull([MODELNUMBER]),0,DSum("[QTYDLVD]","PRODUCT SOLD QRY","[MODELNUMBER]=" & "[PRODUCTNUMBER]"))

this works fine

in the query "PRODUCT SOLD QRY" i have PRODUCTS field and SPARES field

Now in the Dsum along with the above code how can i get only the PRODUCTS
Now it is giving me the total of all qty including PRODUCTS and SPARES equating the MODELNUMBER and PRODUCTNUMBER

PLEASE HELP

 

[Brianwarnock]

I assume that QTYDLVD contains the qty whether for Products or Spares and which is indicated in those fields , therefore if for Spares I assume the PRODUCTS field contains is null and you can check for that.


Brian