Simple SQL QUestion

[united07]

I have 2 columns in my table. 1. is 'Household' 2. is 'Household Members'. There are multiple members for each household. How do I find the average number of members per household.

 

[PHV]

Tou may try something like this:
SELECT Household, AVG('Household Members') As AverageMembers
FROM yourTable
GROUP BY Household

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244