I am trying to print a report from a database. There are two fields. One field is part numbers and the other field is quantity sold.
I am trying to generate a concise report that will tell me very simply that I sold 12 piece of part number ABCD. The database was generated from everything we invoiced in the year 2000. The are about 3800 records in the database. I have indexed the data by part number, I just don't know how to make the report add up all the quantities sold.
Thank you for you help.
-Gary
gharrison@shelgem.com