Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping Error (Access 97)

    Hi folks - I have a simple query sorted on an inventory date. I have made a report with this and related data in the detail section, and grouped it in ascending order. However, when I try to group this on month with a sum in the group footer, it totals the month just fine,but sends the dates out of order. What am I doing wrong?? I have tried swapping bits around in group header sections rather than detail, etc. but am not getting anywhere....

    Many thanks Marion

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Grouping Error (Access 97)

    Reports ignore any sorting done in the data source. You have to specify it in the Sorting and Grouping window. Put the inventory date into the grid twice. Group by month on the first entry, and just sort ascending on the second entry. This will make the dates sort within each month.

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping Error (Access 97)

    Worked like a dream Hans - thanks!

Posting Permissions

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