Thanks Jim Reinardy and Leif Guldbrand for your feedback!

I was able to do it easily in MS Access and also by transferring the data 
up to the iSeries and simply do some queries over to prepare my report.  I 
am still willing to know how to do it in Excel though.  A friend told me 
that I can also use pivot tables but I need to practice...

Thanks everybody!

Peter Vidal 
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111

"My religion consists of a humble admiration of the illimitable superior 
who reveals himself in the slight details we are able to perceive with our 
frail and feeble mind."
-Albert Einstein- (1879-1955)

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.