Hello, I need help grouping and summing records in a report. I created a "Time Tool" folder in the "Assistance Needed" folder to place my files. It contains a zipped copy of my db and two screen shots. The problem report is named rptTeamOR. The first screen shot (capture1) is how the report appears now. The second screen shot (capture2) is the same data keyed into Excel as I want it to appear. There are two differences: 1) all similar function times are summed onto one number on a detail record; 2) there is a total function time for each Michie number. Keep in mind that each product has a unique Michie number, so the two terms can be used interchangeably. My boss wants to view the report and quickly see how much time was spent on each Michie number (each product). I use Access 2007 and my experience level is intermediate. Thanks for your help.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar