Sorting & Grouping Problem

[razorking]

I have an odd request. Was not even sure how to title it, explaining it will be a challenge as well. But will give it a try:

I have a report based upon a query. I queried the same table twice - seperate queries and then joined the two queries in the query that the report is based upon:
Query 1: this shows customer orders and item numbers
Query 2: shows purchase orders and item numbers
Final query: joins on item number from queries 1 & 2. The purpose is to show all customer orders and to show any/all purchase orders where the item numbers match.

What this means of course is that if I have more than one purchase order# for a single item on a customer order it displays in the query results like this:
customer order#/Line_____Item#________Purchase Order#
223125/0010____________ABC123__________900215
223125/0010____________ABC123__________900330

Now on my report I don't really want to list order 223125 line 0010 twice. I just want to show that order/line and then list all applicable PO#'s (900215, 900330) in the group header (grouped on customer order#).

I hope this makes sense. Am sure there is a way to accomplish this...but thus far it eludes me.

 

[pbaldy]

Not sure I understand your structure, but you should be able to adapt one of these:

http://www.mvps.org/access/modules/mdl0004.htm

http://support.microsoft.com/kb/210163/en-us

 

[razorking]

Thanks, this may be what I need. I have not had a chance to get back to it yet.

Stay tuned.