>I'm designing an invoicing application, (this is about my 6th, one) >I have always had doubts as to how to handle the totaling of the >child records (detail) for an invoice. > >Could someone give me any ideas on what would be the best way >to get the total for an invoice? > >Some methods I have used before are: sum, scan, memory variables and so on, >but somehow I believe that there has to be a fast and elegant way of doing this. There are so many ways to "skin a cat" and as long as the end result works (you eat the cat), do it the way you feel most comfortable. I usually use SQL to get totals. But many people use SUM.