Using SUM function
From: ******** <NICKB_at_KUBOTA.CO.UK>
Date: 2000/05/02
Message-ID: <390eeddf.0_at_tahiti.alcom.co.uk>#1/1
Date: 2000/05/02
Message-ID: <390eeddf.0_at_tahiti.alcom.co.uk>#1/1
[Quoted] Hello guys and gals.
I have a problem.I need to turn the following query table into summary format. It contains sales information:
YEAR CUST ITEM SALES_QTY
1998 ALBA TRACTOR 1
1998 ALBA TRACTOR 1
1998 ALBA TRACTOR 1
1997 ASH TRAILER 2
1996 ASH TRAILER 1
Ideally the finished format should look like this:
YEAR CUST ITEM SUM(SALES_QTY)
1998 ALBA TRACTOR 3
1997 ASH TRAILER 2
1996 ASH TRAILER 1
Please help,
regards,
Nick.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue May 02 2000 - 00:00:00 CEST