C
Clare
I've used the northwind database as a guide and so my sales order form has
the unit price, discount and then 'extended price' which is a calculated
field ExtendedPrice:
CCur([tblPro].[UnitPrice]*[tblSODetails].[Quantity]*(1-[tblSODetails].[Discount])/100)*100
To show the sum for each order on the form and on an invoice is no trouble
at all - =Sum([ExtendedPrice]) and then the grand total is obviously
=[Subtotal]+[ShippingCost]
However I also want to keep a track of invoices separatly on another form
and so be able to print out reports for cash flow forecasts... So for each
unique invoice number I'd like to show the invoice date and when it's due.
How can I sum the total of all ExtendedPrice fields for each unique invoice
number?
Thanks in advance for any help.
the unit price, discount and then 'extended price' which is a calculated
field ExtendedPrice:
CCur([tblPro].[UnitPrice]*[tblSODetails].[Quantity]*(1-[tblSODetails].[Discount])/100)*100
To show the sum for each order on the form and on an invoice is no trouble
at all - =Sum([ExtendedPrice]) and then the grand total is obviously
=[Subtotal]+[ShippingCost]
However I also want to keep a track of invoices separatly on another form
and so be able to print out reports for cash flow forecasts... So for each
unique invoice number I'd like to show the invoice date and when it's due.
How can I sum the total of all ExtendedPrice fields for each unique invoice
number?
Thanks in advance for any help.