 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / April 2007Calculating Grand Total
Using a subform I do calculate the costs of a specific kind of expenses. The kind of expenses are selected in the primary form using a combobox. Withing the subform now I want to have a textfield with the grand total of all expenses within the expense table. For the expenses of a specific kind I use =sum([me.expenseprice]) but what to do for the grand total? Hi, you can try to use DSum: =DSum("expenseprice","YourExpensesTable")  SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Using a subform I do calculate the costs of a specific kind of expenses. > The kind of expenses are selected in the primary form using a combobox. > Withing the subform now I want to have a textfield with the grand total of > all expenses within the expense table. > For the expenses of a specific kind I use =sum([me.expenseprice]) but what > to do for the grand total? Hi Alex, Sorry, but I get an error telling me that I use wrong separator and so on using dsum. using =Sum([Expenses]![ExpenseBedrag]) gives me within the sub-form ofcourse the same value. > Hi, > you can try to use DSum: [quoted text clipped - 7 lines] > > For the expenses of a specific kind I use =sum([me.expenseprice]) but what > > to do for the grand total? Hi, then try to use semicolon: =DSum("expenseprice";"YourExpensesTable") and do not forget to put correct table/field names there SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Hi Alex, > Sorry, but I get an error telling me that I use wrong separator and so on [quoted text clipped - 17 lines] >> > what >> > to do for the grand total? Thanks, Alex, It works. greetings Harry > Hi, > then try to use semicolon: [quoted text clipped - 24 lines] > >> > what > >> > to do for the grand total? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.