Sabtu, 26 Mei 2012

[MS_AccessPros] Group by issue

 

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar