combining records lines in Access 1

[doloresmeehan]

Hi,

I am trying to combine text values in Access. The source data looks like this:

item ID sequence text
00356 001 pillow with lace edge
00356 002 that has white little flowers

What I need to see is:
ItemID Text
00356 pillow with lace edge that has white flowers

Please help,
Thanks

 

[dhookom]

Check out faq701-4233.

Duane
Hook'D on Access
MS Access MVP

 

[doloresmeehan]

Thanks Duane,