Totalling

[TIM]

Hi all____can someone point me in the right direction please.____Master table is customer which has grouping on sales_per + sales_type____There is a a relationship to a second table Cust_prod and third table Product ____In product there is the product code and discription and a logical flag that defines if the item is a capital item or not____on the record line there is a field from cust_prod which i need to total based on the logical flag held in product. In other words if the flag in product is .t. then the Corresponding items in cust_prod are part of the total, if it^s .f. then there not____Any ideas gratefully received :-)____Regards____Tim

[TIM]

Forgot to say the total needs to sit on the sales_per group footer

[TIM]

Help!!!! :-)

[Lisa_(Guest)]

Maybe try:__create a field counter using the Total funciont for product code. Play with the conditional statement on that counter tally. Reset the code according to the group footer.____Depending on what you want displayed on the report output, use the band line condition to show/supress printing.____