Hi,
I'm quite new at building forms and I was wondering if there was a quicker way to make the summation of a series of fields. For example, let's say I have four numeric fields that I want to sum :
actual_budget_electricity
actual_budget_carinsurance
actual_budget_food
actual_budget_restaurant
The only way I know to do this is :
Sum(form1.subform1.actual_budget_electricity,actual_budget_carinsurance,actual_budget_food,actual_budget_restaurant)
However, I was wondering if there was a kind of "wildcard" I could use to command the form to summarize every field that starts with "actual_budget", like, for example :
Sum(form1.subform1.actual_budget[*])
Does such a thing exist?