a query to view all the invoice numbers and their totals

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

if I have a table containting InvoiceNumber, ItemCode, ItemPrice
What will be a query to view all the invoice numbers and their totals
 
SELECT InvoiceNumber, Sum(ItemPrice) FROM {yourTable} GROUP
BY InvoiceNumber

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
if I have a table containting InvoiceNumber, ItemCode, ItemPrice
What will be a query to view all the invoice numbers and
Click to expand...
their totals
 
aa said:
if I have a table containting InvoiceNumber, ItemCode, ItemPrice
What will be a query to view all the invoice numbers and their totals
Click to expand...

Try:

SELECT InvoiceNumber, Sum(ItemPrice) As TotalPrices
FROM TableName
 
Back
Top