Is it possible to combine or merge text data into one field in a query 2

[Johnnycat1]

This question is a bit more complex than just doing a simple =[text1] & [text2]

What I am looking for is the ability to perform an aggregate function or something that acts like an aggregate on the same field when it contains text. I expect that there is some SQL that will do this but I have been unable to find it.

In a query that has the following fields
Bid Date Bid Info
5/19/2005 Centennial Plaza Retail Center - John O
5/19/2005 CHURCH - John O
5/19/2005 Church Site Work - John O
5/24/2005 Emergency Essentials - John O
5/26/2005 Camp Williams JLTC Bldg-2 - John O
5/26/2005 Bear River Health Department - John O

Help is greatly appreciated!

I need to combine data where the date is the same into the same cell and have a new line inserted into the cell when there is more than one item per date.

The result would be something like this:
Bid Date Bid Info
5/19/05 Centennial Plaza Retail Center - John O
CHURCH - John O
Church Site Work - John O
5/24/05 Emergency Essentials - John O
5/26/05 Camp Williams JLTC Bldg-2 - John O
Bear River Health Department - John O

 

[Johnnycat1]

PH,

You are the master!!! That did the trick.

Once again, thank you for the help.