Drew Wutka
DWUTKA at marlow.com
Tue Nov 4 10:18:33 CST 2003
Group By Emplid, Name, Rate, and Title. Sum both Hours fields. Drew -----Original Message----- From: Brown, Bryan [mailto:Bryan.Brown at acsalaska.com] Sent: Monday, November 03, 2003 6:42 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Summarizing like data - suggestions? Hi everyone, I listen a lot and offer help when I'm able (which, as a relative newcomer when compared to many of you, is not often) and now I could use some help. I have two tables of like data (or it could be one table with multiple rows of similar records) and I need to combine the records when appropriate into one table... It seems simple enough, but it eludes me. I have about 3000 records to compare and summarize. If all data elements, except hours, are the same then, I add the hours, else I have to have separate entries. Any suggestions would be appreciated - Thanks! Example of Multiple rows in one table: Sample Data Before Summary Emplid;Name;Rate ;Title ;Hours1;Hours2 100001;Fred; 9.50;Dishwasher;40 ;22 100001;Fred;15.00;Head Cook ;35 ;18 100002;Bob ; 9.00;Waiter ;40 ;22 100002;Bob ; 9.00;Waiter ;60 ;10 Desired Result Data after Summary Emplid;Name;Rate ;Title ;Hours1;Hours2 100001;Fred; 9.50;Dishwasher;40 ;22 100001;Fred;15.00;Head Cook ;35 ;18 100002;Bob ; 9.00;Waiter ;100 ;32 This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you. ACS3/11/2003 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com