Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Adding hours for each area... I'm stuck!

Discussion in 'Information Technology' started by Luna Saisho, Jul 28, 2006.

  1. Luna Saisho

    Luna Saisho
    Expand Collapse
    Guest

    Hi,

    I'm somewhat new to Access, but have made a succesful database with one
    problem that I'm hoping someone can help with. I am so stuck here...

    What I have is a database that stores information on our warehouse
    employees. The parts that matter here are... Area - Where they worked that
    day (Shipping, receiving, palletizer, depal)... Hours worked that day...
    Without bogging you down with the whole thing, it is trying to find out
    averages for what the employees have done. I've created a query that figures
    out pretty much everything. It summarizes by each employee, but its the
    summary at the end of the report with issues.

    My problem is this... I want to total the hours for each of the four areas
    separately, so I'd have a total of hours worked in Shipping, Palletizer, etc.
    Should I do this on the Query, the report, or someplace else? I've tried
    using the DSum expression, but it only seems to want to add up EVERYTHING in
    the table under Shipping (the area I'm experimenting with), not just what is
    displayed in the report.

    Anyone have any ideas? I'm pretty desperate and pulling my hair out with
    this. If I get this bit, then I'm finally done!! :)

    Thank you so so much in advance,
    Stephanie

    P.S. Yes, I posted something about this earlier, but my wording, bluntly,
    stunk. So I thought I'd repost it a lot clearer. I hope I did... :)
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---the Finest Hours Theatre, Movies & Cinema Feb 6, 2016
    about 8 hours! Blogs Oct 16, 2015
    Punjab entrepreneur sets up 10-storey building in Mohali in 48 hours Punjab, Punjabi, Punjabiyat Dec 3, 2012
    Kindly put some light on final hours of Guru Gobind Singh Jee's Human Life. Sikh Sikhi Sikhism Jul 29, 2012
    Bhagat Singh's Final Hours History of Sikhism Oct 14, 2011

  3. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Luna - how do you want your Report to display this? If you are ok with one
    group and then the other, etc, the easiest way to turn on the Grouping on the
    report layout and do your sums, counts, etc in the Group Footer. You can then
    put the sums, counts etc in the Report Footer and get the totals.

    Hope this helps -- yours Dika

    "Luna Saisho" wrote:

    > Hi,
    >
    > I'm somewhat new to Access, but have made a succesful database with one
    > problem that I'm hoping someone can help with. I am so stuck here...
    >
    > What I have is a database that stores information on our warehouse
    > employees. The parts that matter here are... Area - Where they worked that
    > day (Shipping, receiving, palletizer, depal)... Hours worked that day...
    > Without bogging you down with the whole thing, it is trying to find out
    > averages for what the employees have done. I've created a query that figures
    > out pretty much everything. It summarizes by each employee, but its the
    > summary at the end of the report with issues.
    >
    > My problem is this... I want to total the hours for each of the four areas
    > separately, so I'd have a total of hours worked in Shipping, Palletizer, etc.
    > Should I do this on the Query, the report, or someplace else? I've tried
    > using the DSum expression, but it only seems to want to add up EVERYTHING in
    > the table under Shipping (the area I'm experimenting with), not just what is
    > displayed in the report.
    >
    > Anyone have any ideas? I'm pretty desperate and pulling my hair out with
    > this. If I get this bit, then I'm finally done!! :)
    >
    > Thank you so so much in advance,
    > Stephanie
    >
    > P.S. Yes, I posted something about this earlier, but my wording, bluntly,
    > stunk. So I thought I'd repost it a lot clearer. I hope I did... :)
     
  4. Luna Saisho

    Luna Saisho
    Expand Collapse
    Guest

    Hiya! Here's how I kind of have it laid out already:

    -----
    Name Shift
    Date That employee's stats for the day
    Area More stats :)
    Totals & Averages of all entries displayed for that employee

    Summary of everyone displayed, averages and totals again.
    -----

    Name and Shift and the first Totals & Averages are the name group, Date,
    Stats and Area are in the Detail group, and the summary of everyone is in the
    report footer, to display at the end.

    So all of that works great, but I found that I was using the total hours
    worked, without it being in an area, which made the averages come out wrong..
    They wanted that added about 3/4 through my work on it. So basically, I am
    trying to get it to do this:

    An employee can work in one of four areas. What I need to do is make a way
    so it looks at the area, and adds hours to a variable for that area alone.
    So if they work in Shipping that day, it adds to ShippingHours, at the
    palletizer, PalletizerHours.

    I've tried using DSum, but the total comes out many times too large.
    Honestly, I'm not sure if I'm using DSum correctly, since I've found many
    ways to format it here on MS' site.

    Phew, long winded... I hope that makes it more understandable. :) Thank
    you for your help!
    Steph

    "Kernow Girl" wrote:

    > Hi Luna - how do you want your Report to display this? If you are ok with one
    > group and then the other, etc, the easiest way to turn on the Grouping on the
    > report layout and do your sums, counts, etc in the Group Footer. You can then
    > put the sums, counts etc in the Report Footer and get the totals.
    >
    > Hope this helps -- yours Dika
    >
    > "Luna Saisho" wrote:
    >
    > > Hi,
    > >
    > > I'm somewhat new to Access, but have made a succesful database with one
    > > problem that I'm hoping someone can help with. I am so stuck here...
    > >
    > > What I have is a database that stores information on our warehouse
    > > employees. The parts that matter here are... Area - Where they worked that
    > > day (Shipping, receiving, palletizer, depal)... Hours worked that day...
    > > Without bogging you down with the whole thing, it is trying to find out
    > > averages for what the employees have done. I've created a query that figures
    > > out pretty much everything. It summarizes by each employee, but its the
    > > summary at the end of the report with issues.
    > >
    > > My problem is this... I want to total the hours for each of the four areas
    > > separately, so I'd have a total of hours worked in Shipping, Palletizer, etc.
    > > Should I do this on the Query, the report, or someplace else? I've tried
    > > using the DSum expression, but it only seems to want to add up EVERYTHING in
    > > the table under Shipping (the area I'm experimenting with), not just what is
    > > displayed in the report.
    > >
    > > Anyone have any ideas? I'm pretty desperate and pulling my hair out with
    > > this. If I get this bit, then I'm finally done!! :)
    > >
    > > Thank you so so much in advance,
    > > Stephanie
    > >
    > > P.S. Yes, I posted something about this earlier, but my wording, bluntly,
    > > stunk. So I thought I'd repost it a lot clearer. I hope I did... :)
     
  5. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Luna - how have you set up the Report Grouping? It sounds like if you add
    a Group Footer and put your stats there you'll get what you want. You can
    have stats in both Headers and Footers, and can have layers of Groups. As you
    found the stats in the Report Footer do the whole report. HTH --- Dika

    "Luna Saisho" wrote:

    > Hiya! Here's how I kind of have it laid out already:
    >
    > -----
    > Name Shift
    > Date That employee's stats for the day
    > Area More stats :)
    > Totals & Averages of all entries displayed for that employee
    >
    > Summary of everyone displayed, averages and totals again.
    > -----
    >
    > Name and Shift and the first Totals & Averages are the name group, Date,
    > Stats and Area are in the Detail group, and the summary of everyone is in the
    > report footer, to display at the end.
    >
    > So all of that works great, but I found that I was using the total hours
    > worked, without it being in an area, which made the averages come out wrong..
    > They wanted that added about 3/4 through my work on it. So basically, I am
    > trying to get it to do this:
    >
    > An employee can work in one of four areas. What I need to do is make a way
    > so it looks at the area, and adds hours to a variable for that area alone.
    > So if they work in Shipping that day, it adds to ShippingHours, at the
    > palletizer, PalletizerHours.
    >
    > I've tried using DSum, but the total comes out many times too large.
    > Honestly, I'm not sure if I'm using DSum correctly, since I've found many
    > ways to format it here on MS' site.
    >
    > Phew, long winded... I hope that makes it more understandable. :) Thank
    > you for your help!
    > Steph
    >
    > "Kernow Girl" wrote:
    >
    > > Hi Luna - how do you want your Report to display this? If you are ok with one
    > > group and then the other, etc, the easiest way to turn on the Grouping on the
    > > report layout and do your sums, counts, etc in the Group Footer. You can then
    > > put the sums, counts etc in the Report Footer and get the totals.
    > >
    > > Hope this helps -- yours Dika
    > >
    > > "Luna Saisho" wrote:
    > >
    > > > Hi,
    > > >
    > > > I'm somewhat new to Access, but have made a succesful database with one
    > > > problem that I'm hoping someone can help with. I am so stuck here...
    > > >
    > > > What I have is a database that stores information on our warehouse
    > > > employees. The parts that matter here are... Area - Where they worked that
    > > > day (Shipping, receiving, palletizer, depal)... Hours worked that day...
    > > > Without bogging you down with the whole thing, it is trying to find out
    > > > averages for what the employees have done. I've created a query that figures
    > > > out pretty much everything. It summarizes by each employee, but its the
    > > > summary at the end of the report with issues.
    > > >
    > > > My problem is this... I want to total the hours for each of the four areas
    > > > separately, so I'd have a total of hours worked in Shipping, Palletizer, etc.
    > > > Should I do this on the Query, the report, or someplace else? I've tried
    > > > using the DSum expression, but it only seems to want to add up EVERYTHING in
    > > > the table under Shipping (the area I'm experimenting with), not just what is
    > > > displayed in the report.
    > > >
    > > > Anyone have any ideas? I'm pretty desperate and pulling my hair out with
    > > > this. If I get this bit, then I'm finally done!! :)
    > > >
    > > > Thank you so so much in advance,
    > > > Stephanie
    > > >
    > > > P.S. Yes, I posted something about this earlier, but my wording, bluntly,
    > > > stunk. So I thought I'd repost it a lot clearer. I hope I did... :)
     
  6. Luna Saisho

    Luna Saisho
    Expand Collapse
    Guest

    Hiya!

    Thanks for another reply. ^_^ You are so close to what I need! Just look
    over there, a bit more to the right... Good. hehe

    I have the group footers and such all set up and everything but one thing is
    looking great, except for the thing sprung on me at the beginning of the week.

    The problem is that I need to add up the hours per area the material
    handlers work. So if they're in Shipping, it adds to Shipping... Palletizer
    to palletizer, and so on. But the hours are in one pool, and not separated
    into those catagories.

    I've tried doing DSum, but after some research, I found that it computes
    DSum before the grouping happens, thus giving me ALL the hours for each area,
    regardless if they are shown in the report or not. Is there something
    similar to DSum that will work on the grouping level?

    Thank you once again! ^_^
    Steph
    "Kernow Girl" wrote:

    > Hi Luna - how have you set up the Report Grouping? It sounds like if you add
    > a Group Footer and put your stats there you'll get what you want. You can
    > have stats in both Headers and Footers, and can have layers of Groups. As you
    > found the stats in the Report Footer do the whole report. HTH --- Dika
    >
    > "Luna Saisho" wrote:
    >
    > > Hiya! Here's how I kind of have it laid out already:
    > >
    > > -----
    > > Name Shift
    > > Date That employee's stats for the day
    > > Area More stats :)
    > > Totals & Averages of all entries displayed for that employee
    > >
    > > Summary of everyone displayed, averages and totals again.
    > > -----
    > >
    > > Name and Shift and the first Totals & Averages are the name group, Date,
    > > Stats and Area are in the Detail group, and the summary of everyone is in the
    > > report footer, to display at the end.
    > >
    > > So all of that works great, but I found that I was using the total hours
    > > worked, without it being in an area, which made the averages come out wrong..
    > > They wanted that added about 3/4 through my work on it. So basically, I am
    > > trying to get it to do this:
    > >
    > > An employee can work in one of four areas. What I need to do is make a way
    > > so it looks at the area, and adds hours to a variable for that area alone.
    > > So if they work in Shipping that day, it adds to ShippingHours, at the
    > > palletizer, PalletizerHours.
    > >
    > > I've tried using DSum, but the total comes out many times too large.
    > > Honestly, I'm not sure if I'm using DSum correctly, since I've found many
    > > ways to format it here on MS' site.
    > >
    > > Phew, long winded... I hope that makes it more understandable. :) Thank
    > > you for your help!
    > > Steph
    > >
    > > "Kernow Girl" wrote:
    > >
    > > > Hi Luna - how do you want your Report to display this? If you are ok with one
    > > > group and then the other, etc, the easiest way to turn on the Grouping on the
    > > > report layout and do your sums, counts, etc in the Group Footer. You can then
    > > > put the sums, counts etc in the Report Footer and get the totals.
    > > >
    > > > Hope this helps -- yours Dika
    > > >
    > > > "Luna Saisho" wrote:
    > > >
    > > > > Hi,
    > > > >
    > > > > I'm somewhat new to Access, but have made a succesful database with one
    > > > > problem that I'm hoping someone can help with. I am so stuck here...
    > > > >
    > > > > What I have is a database that stores information on our warehouse
    > > > > employees. The parts that matter here are... Area - Where they worked that
    > > > > day (Shipping, receiving, palletizer, depal)... Hours worked that day...
    > > > > Without bogging you down with the whole thing, it is trying to find out
    > > > > averages for what the employees have done. I've created a query that figures
    > > > > out pretty much everything. It summarizes by each employee, but its the
    > > > > summary at the end of the report with issues.
    > > > >
    > > > > My problem is this... I want to total the hours for each of the four areas
    > > > > separately, so I'd have a total of hours worked in Shipping, Palletizer, etc.
    > > > > Should I do this on the Query, the report, or someplace else? I've tried
    > > > > using the DSum expression, but it only seems to want to add up EVERYTHING in
    > > > > the table under Shipping (the area I'm experimenting with), not just what is
    > > > > displayed in the report.
    > > > >
    > > > > Anyone have any ideas? I'm pretty desperate and pulling my hair out with
    > > > > this. If I get this bit, then I'm finally done!! :)
    > > > >
    > > > > Thank you so so much in advance,
    > > > > Stephanie
    > > > >
    > > > > P.S. Yes, I posted something about this earlier, but my wording, bluntly,
    > > > > stunk. So I thought I'd repost it a lot clearer. I hope I did... :)
     

Share This Page