group query help, please

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
 
J

Jeff Boyce

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.
 
Top