SUM not giving correct result?

[ulises48]

Hello and good day.
Why this SUM code gives me only the value in the first field of my table?

PUBLIC xNumPedRec
xNumPedRec=ALLTRIM(THISFORM.numped1.VALUE)
SUM tblorders.totprod ALL for ALLTRIM(tblorders.numped)=xNumPedRec TO xRecalc
THISFORM.text1.VALUE=xRecalc (xRecalc here shows only the value of the first field in my table)

Thank you in advance

 

[ulises48]

Never mind. I swear I did not touch the code and it's working now!!!

 

[Olaf Doschke]

No matter, if the issue is solved overall or just solved for now:

The for condition "for ALLTRIM(tblorders.numped)=xNumPedRec" can limit the summing to only certain records.

So the result is influenced by what is entered in numped1.value of the form, you may want == instead of = here.

Bye, Olaf.