Syntax for: Average of Field values
Posted on 2009-07-08
I have a client database, which holds records of client data including their purchase rates (ie transactions per year). Now I'd like to determine the average Purchase rate for the whole group of clients.
Can a sql be written to calculate the average??? ( or do i need to set up a loop, add each purchase rate and the divide by the nr of clients)
eg (VB6, Access 2003 database)
sql = "Select distinct Client_ID from CLIENT_DETAILS "
?Sql .......determine average rate ????
Set dsClients = CURDB.OpenRecordset (sql, dbOpenDynaset)