Sorting by one field, Grouping by another?

  • Thread starter Thread starter helenerz
  • Start date Start date
H

helenerz

Hi,

I'm having trouble getting my report grouping correct. I'm trying to
print invoices (report grouped by OrderNumber), but sorted in order by
the number of items and location.

I created a query that totaled the number of items and location, and
used that to make a new query with the order information and the sort
by fields (put together as NumLoc - ex: 1A, 2B, 2A).

The report Sorting and Grouping is set as:

NumLoc Ascending
No group header, footer, group on each value, group interval
= 1, keep together = no

OrderNumber Ascending
Group header, group footer, Group on each value, Group
interval = 1, Keep together = no


When I test it, it prints sorted and grouped by the OrderNumber field
only. It doesn't seem to take NumLoc into consideration at all.


I would want the report to be grouped by the OrderNumber, but sorted
by NumLoc.

Example:

OrderNumber = 10
NumLoc = 1A

OrderNumber = 2
NumLoc = 1A

OrderNumber = 1
NumLoc = 2A

OrderNumber = 3
NumLoc = 2B


Can anyone help figure out what I'm doing wrong?
 
I would try display the group header and display the NumLoc field. Do you
realize the NumLoc field would sort like:
1A
10A
15B
2A
 
Back
Top