Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
show all invoice totals
0 views
Skip to first unread message
Cheri
May 24, 2004, 10:41:32 AM5/24/04
to
An invoice may have more than one item to it. Each item
is entered individually under one invoice number. I just
want a query to show the invoice total for all the items
purchased, not individually.
is entered individually under one invoice number. I just
want a query to show the invoice total for all the items
purchased, not individually.
thank you
Cheri
Rowan
May 24, 2004, 11:06:05 AM5/24/04
to
Select Invoice_Number, sum(value) as Invoice_Total
from Table
Group by Invoice_Number
0 new messages