You can use Select - SQL also.
>Hello fellow programmers around the world.
>
>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.
>
>Thanx in advance for any help.
>
>Alfred
>
>p.d.
>
>does anyone else use sundays to catch up?
Igor Gelin
Database Developer