Expression for Householding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


Rose said:
I am using an imported database and need to household addresses with more
Click to expand...
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.
 
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
 
Back
Top