Combine Multiple Records into One Record

[Bill B.]

Hello,

I have a table which contains Employee and Dependent information in multiple
records. Can a query be built to combine the Employee and Dependent
information into one record? TIA

 

[Allen Browne]

I take it that there's a self-join here - a DependsOnID field that looks up
the EmployeeID in the same table?

If so, you could use this function to return a concatenated string of the
dependents beside each employee:
Concatenate values from related records
at:
http://allenbrowne.com/func-concat.html

 

[Bill B.]

Allen,

Thanks for the help. First I made tables from the queires that gave me my
results but I could not establish a one to many realtionship so the query
would not work. Then I tried the module and as I was reading the notes my
strField argument is multi-valued and since I am using A2003 this is a no go
too.

Bill B.

 

[Allen Browne]

Not sure I followed that.

The function supports concatenating values from a multi-valued field in
A2007, but it is written so that it works in previous versions (i.e. it does
not require that you're concatenating from a MVF.)

But it sounds like the roadblock occured further back somewhere with your
query/table design.