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

    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

    Date
    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,
    Sandy

  2. #2
    Join Date
    Jul 2005
    Posts
    8

    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
    Location
    metro Detroit
    Posts
    634
    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
  •