Thank you for coming back to me. You are right to suggest that I'll need to know the total number of persons in each household to have it easy, however, just in case I missed anything, this is a clarification,
I'm hoping to create a Household Table using a query which processes my existing...
Hi,
Could you show me how to convert records (in the example below)with the same HHID into one long record?
HHId Person FName SName Age
10 1 Fred Smith 75
10 2 John Smith 35
11 1 Mark Jones 46
12...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.