Unbound Form - sum of field in table 1

[fredka]

I have an unbound form that I use to run reports. On that form, I have a field named financefilemembers. In this field I want to hold the total number of "members" from a table named tblfinancefile.

I thought I could just put this in the open even of the form:

Me!financefilemembers.controsource = "SELECT Sum(FinanceFile.MEMBERS) AS SumOfMEMBERS FROM FinanceFile;"

However, that is not working.

Can someone point me in the right direction.

Thanks!!!!

Fred

 

[RoyVidar]

If you want to use controlsource, then you'd need one of the Domain Aggragetes - if I remember the syntax right (check it in the help file);

[tt]=DSum("Members","FinanceFile")[/tt]

You say count, but show sum, check out the other Domain Aggregates too, DCount, DMax...

Roy-Vidar

 

[fredka]

Thanks so much for the help!!! I am not sure why I did not think that would work since I use dlookup all the time.

Thanks again, I appreciate it!!!! Here is what I ended up with:

Me.financefilemembers.Value = DSum("[Members]", "FinanceFile")

Fred

 

[PHV]

total number of "members" from a table named tblfinancefile
Me!financefilemembers.Value = DCount("Members", "FinanceFile")


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886