The numbers in my second screen shot were not in hours/minutes format. I just replaced it with a corrected version. Sorry about that.
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> The screen shots suggest data for 12/18/2012 but there is no data matching that date. You sample screen shots should match with the data and you need to provide the filter values.
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: bradgriffis@...
> >
> > 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 (4) |
Tidak ada komentar:
Posting Komentar