Sorting question?????

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access2000, I have a report created called "PackingSlip". It's set up so
that if there are multiple client orders under the same "ClientOrderNumber",
each order will appear on one "PackingSlip". For example, if there are
three orders under the same client order number, all three order numbers
will be on the single Packing Slip.

Each "Packing Slip" also has a "JobNumber", which also appears on the
"PackingSlip". When the user is ready to ship an order, the Job Ticket and
Packing Slip are printed out. The Job Ticket is sorted by the JobNumber,
and prints out numerically in ascending order. It has been requested that
the PackingSlip also print out sorted by JobNumber in ascending order. The
problem I have, is that if I change the sorting and grouping to JobNumber
instead of the current ClientOrderNumber, I receive a Packing Slip for each
order as an individual. The PackingSlip no longer takes the orders with the
same ClientOrderNumber and puts them on one PackingSlip.

I hope this isn't to confusing. If you can help, please.
----------------------------------------------------------------------------
--------------------
PACKING SLIP
================================================================
CLient Order Number Qty Ordered PartNumber
JobNumber
----------------------------------------------------------------------------
--------------------
ED12345 2 1234
5678
ED12345 1 7574
5679
ED12345 5 6235
5680
 
What is the query?

Can you not

Group by ClientOrderNum, JobNum
Order by ClientOrderNum, JobNum

Probably looking at it too simplistically. Let's look at
the query!!
-----Original Message-----
In Access2000, I have a report created
Click to expand...
called "PackingSlip". It's set up so
 
Back
Top