Hi all,

If I had any hair, I'd be pulling it out over this one.

On my Invoice form, I have the following fields:

(in the Detail band)
qty_select unit_price qty_select*unit_price (for the extended line total)

In the Group Footer band, I have the extended line total summed. It's perfectly fine. I also have three other fields there:

misc_chg
sales_tax
frt_chg

And a fourth field that adds those three fields to the subtotal for a grand invoice total.

The problem: it doesn't just add the above three fields one time. It adds them one time for each line of detail on the invoice. For example, for an invoice with two detail lines, I get this:

Sub : $400
Misc: 0
Tax : 0
Frt : 100
Tot : $600

If I display the misc_chg, sales_tax and frt_chg fields on the form for testing purposes, they're correct (just $100 for frt). But why is it adding those lines once for each line of detail, even though it's displaying correctly on the form? I want to add my subtotal, then each of the other three displayed items (misc, tax, frt) to get my grand total.

This oughta be simple. In fact, it probably is. But I'm just not seeing it.

Thanks!

John