Report summary

  • Thread starter stephendeloach via AccessMonster.com
  • Start date
S

stephendeloach via AccessMonster.com

I have a report (InvoiceSummary) that summarizes all of my invoices that are
in the DrillingInvoice form. I have my InvoiceSummary Report run from a query,
here it is in SQL...
SELECT Charges.UnitPrice, Charges.Quantity, Charges.Description, Charges.
[Invoice#] AS [Charges_Invoice#], Charges.TaxableChk, Table1.[BillTo:],
Table1.WellName, Table1.[Parish/County], Table1.InvoiceDate, Table1.[Invoice#]
AS [Table1_Invoice#], Table1.NetAmount, Table1.CompanyFrom, Table1.Tax,
Charges.Expendable, Table1.RigName, Table1.[TSWSin#], Table1.Date, Table1.
AmtPaid, Table1.Balance, Charges.netamt
FROM Table1 INNER JOIN Charges ON Table1.[Invoice#] = Charges.[Invoice#];

What my problem is each invoice has many different Descriptions. When the
InvoiceSummary is run, it shows each description from the same invoice on
seperate lines. Is there a way I can make the summary show each invoice#, the
multiple descriptions, and the amount of the invoice on one line? If you need
to see the db I will email it to anyone who can help. Thanks.

Stephen
 
Top