I am trying to get the avg number of household member per application:
The two fields that would be used is the applicationID and HouseholdID.
Something like this:
SELECT Avg(tblApplicationHousehold.HouseholdID) AS AvgOfHouseholdID, tblApplicationHousehold.ApplicationID
FROM tblApplicationHousehold
GROUP BY tblApplicationHousehold.ApplicationID;
But this returns a number per application, I just want to have a single avg returned for all applications.
Thanks,
Arthur Lorenzini
Sioux Falls, SD
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar