Combine descriptions into one 1

[mbDutch]

Hello -

Not sure if this is possible but:
I have a single table that contains a part number, an operation number and a memo description.
Detail records look somewhere along the lines of:

Part # Operation # Description
BC-10 10 Pull from freezer
BC-10 20 Cut to size
BC-10 30 Add coloring


What I would like is to have a query that combines the
description field and returns;
Part # Description
BC-10 Pull from freezer, Cut to size, Add coloring.

Is this possible in Access?
I am using MS Access 2003.
Sorry if this was asked before.

Thanks in advance,

Marco

 

[PHV]

faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886