I have a table with 6 fields and I am trying to get the total of one of them, Finance_Expenditure.
I have the following and I am getting '0' returned everytime.
Code:
    Dim TotalEx As Currency
    strSQL = "SELECT SUM (Finance_Expenditure) as TotalEx FROM tbl_Finances"
    rs.Open strSQL, cn, adOpenForwardOnly, adLockReadOnly, adCmdText
    dblExpenditure = TotalEx
Do I have to something with grouping, although I cannot see why as this is the only field I am working with!