C
Cat Chowdy
Hi,
On an invoice form I want to display the sum of the sales amount of the line items. I have an invoice header table and invoice line item table. I want to sum the sales amount and display it on the header part of the form. The sql would be something like "select invoiceno, sum(salesamt) as SummedAmt from tblLineItems where invoiceno = forms!frmInvoice!invoiceno group by invoiceno".
I can figure out how to get the summed value to display.
Any help appreciated.
Thanks,
Cat
On an invoice form I want to display the sum of the sales amount of the line items. I have an invoice header table and invoice line item table. I want to sum the sales amount and display it on the header part of the form. The sql would be something like "select invoiceno, sum(salesamt) as SummedAmt from tblLineItems where invoiceno = forms!frmInvoice!invoiceno group by invoiceno".
I can figure out how to get the summed value to display.
Any help appreciated.
Thanks,
Cat