Calculating Grand Total

[Harry]

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?

 

[Alex Dybenko]

Hi,
you can try to use DSum:

=DSum("expenseprice","YourExpensesTable")

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Harry]

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:

=DSum("expenseprice","YourExpensesTable")

--
Best 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?

 

[Alex Dybenko]

Hi,
then try to use semicolon:

=DSum("expenseprice";"YourExpensesTable")

and do not forget to put correct table/field names there

--
Best 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
using dsum.
using =Sum([Expenses]![ExpenseBedrag]) gives me within the sub-form
ofcourse
the same value.

Hi,
you can try to use DSum:

=DSum("expenseprice","YourExpensesTable")

--
Best 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?

 

[Harry]

Thanks, Alex,
It works.

greetings
Harry

Hi,
then try to use semicolon:

=DSum("expenseprice";"YourExpensesTable")

and do not forget to put correct table/field names there

--
Best 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
using dsum.
using =Sum([Expenses]![ExpenseBedrag]) gives me within the sub-form
ofcourse
the same value.

Hi,
you can try to use DSum:

=DSum("expenseprice","YourExpensesTable")

--
Best 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?