Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005

    Unanswered: Help with Report

    I have to generate a report that lists scrap by the week. I need the individual days to be listed then a total of those days at the bottom of the report. Something like this

    Part Number Mach # Discrepancy Quantity

    The total would have the total for each different part number, discrepancies etc.

    I need to enter in the beginning date and the ending date to get the correct week.

    I know how to get the individual days to show up, but I'm having trouble getting the week total to come out right.

    Any help would be appreciated.
    Thank you,

  2. #2
    Join Date
    Jul 2005

    I have attached a .jpeg of my report

    This is the way I'd like the report to look. It's okay when all I had was data in from last week, now when I add data in for this week, the top data is okay, but it shows all the entries at the bottom.
    Attached Thumbnails Attached Thumbnails qryForDailysandy1.jpg  

  3. #3
    Join Date
    Apr 2004
    metro Detroit
    I can't see the picture that you posted, but have you tried playing with the sorting/grouping dialog in the report's design view?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts