>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's nothing wrong with SUM or a SCAN. Do you have different types of child records, such as for order cancellations? You can also look at the CALC function which lets you sum more than one variable at once. Just make sure your FOR is Rushmore optimizable.

>does anyone else use sundays to catch up?

Tell me about it.

-Adam