group query help, please

  • Thread starter Thread starter Emilio
  • Start date Start date
E

Emilio

I need to have this result:

OrderID Customer Items
3456 Jones Windows, Doors
(where the OrderID appears only once)
-------------------------------------------
Right now I have:

OrderID Customer Items
3456 Jones Windows
3456 Jones Doors

I am a newbie and can't figure this out.
Any help greatly appreciated.

Thanks,
Emilio
 
Emilio

Would something in between work also? As far as queries go, you can't do
that easily. But if you create a report based on your query, and for the
OrderID and Customer, set the HideDuplicates property to Yes, you'll get a
listing (vertical) of Items, without the repeating OrderID and Customer.

Otherwise, if you have to have a comma-separated string of Items, you're
going to need to learn to do some coding.
 
Back
Top