Expression for Householding

[Rose]

I am using an imported database and need to household addresses with more than one person living at the same address. I would like to have it display as the person(s) living at the address, e.g., Bob and Mary Anybody or Bob Anybody, whichever the case may be. I do not like using "The Anybody Household." Is there an expression that will accomplish this? I am no expert. Your help would be much appreciated. Thank you
Rose

 

[Duane Hookom]

You might want to look at this url... watch out for wrapping
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

--
Duane Hookom
MS Access MVP

I am using an imported database and need to household addresses with more

than one person living at the same address. I would like to have it display
as the person(s) living at the address, e.g., Bob and Mary Anybody or Bob
Anybody, whichever the case may be. I do not like using "The Anybody
Household." Is there an expression that will accomplish this? I am no
expert. Your help would be much appreciated. Thank you.

 

[Rose]

Hi Roger, I tried your URL and this is the message I got:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/Otherdownload.asp, line 32

Please advis

Ros

 

[Duane Hookom]

I'm not Roger but I just successfully downloaded the file.