One to Many help?

[brandon20]

Hi,

Im sure this is simple. But I am new to access and dont even know the correct wording to look up my question on the internet.

Lets say I have two different sheets linked together in access.

One sheet displays the data like this:

Wellname Current Status Reservoir Code
A OPEN ZZ
A OPEN BB
A OPEN CC

I need the data to be displayed concatenated in one cell. So I guess maybe a One to Many relationship

I need the data to be displayed like this:
Wellname Current Status Reservoir Code
A OPEN ZZ-BB-CC

How would I do this?
I found some VBA code I guess, but it didnt help that much.
Microsoft Access tips: Concatenate values from related records




Thanks for any help

 

[HiTechCoach]

How would I do this?
I found some VBA code I guess, but it didnt help that much.
Microsoft Access tips: Concatenate values from related records

The code in the link is exactly how you would do it.

"Lets say I have two different sheets linked together in access."

I think you mean tables not sheets (in an excel workbook).


I will assume the table:

tblWells - priamry key is Well ID (auto-number)
tblWellResivors (has foreign key WellID (long))

Wellname Current Status Reservoir Code

Something like:

ConcatRelated("Reservoir Code", "tblWellResivors", "WellID= " & tblWells.[WellID] " and [Current Status] ="& Chr(34)  & tblWellResivors.[Current Status] & Chr(34) )