I am trying to get a balance of invoices that are current, over 30 days, over 60 days and greater then 90 days. I am using four sum commands to temporary variables and them displaying these cariables in a label caption. The total sum is displayed below. My question(s) are is there a way to select these balance by only using one sum command and why does the variable and the amount get displayed on the bottom of the form.
select charge
sum tbalance ;
for charge.account == thisform.pageframe1.page1.txt_acct.value ;
to TOTBAL
select charge
sum tbalance ;
for charge.account == thisform.pageframe1.page1.txt_acct.value ;
to TOTBAL