I’m having a problem trying to figure out how to sum the quantities from my view’s column (#6) based on what is in the same view’s column (#1) (i.e. Column 1 will have 12 different text values, and depending on what the user picks, I want to sum it independently in my “result” field - on my form1)
I’ve created a dialog box which sets the form’s field “A” to the variable…assuming I have to pass it in the following:
Field B:=B
r:= @dbcolumn(“”:“”;“”;“Column”;6);
@SetField(“B”;@sum(r))
…but I’m having a problem figuring it out.
Would it be better capturing “A” in the code… and most importantly… how =(
Thanks
Glen