populate single record with multiple results from a lookup

[j6sander]

Hello,

I have spent the last 3 hours looking for an answer but have had no luck. Please help.

So I have a table [ClientT] and fields [FullName] and [InOut] (InOut is a yes/no field type). I also have a table called [CRFLogT] and a field [Other]. I need to lookup all the clients names in [ClientT]![FullName] where [InOut] = -1 (and again later I will have to lookup where [InOut] = 0). Then I need pull all of those FullName results, concatenate them together and put the string of names into a single record [CRFLogT]![Other].



How?

Thank you very much for your help

Josh

[orange]

Before HOW can you describe in business terms WHAT you are trying to accomplish?

You've told us, sort of, How you want to solve it, but we don't have any idea of what IT is.

Concatenating a string of names into a single record is NOT a typical solution. It can be done but there may be alternatives.

see allen Browne http://allenbrowne.com/func-concat.html