Hi, I want to do some calculated fields in a main form to show the total payments, adjustments and outstanding balance. The main form data comes from my customers table and the payments and payment types come from a seperate transactions table.
I thought this would be simple but I'm finding it's not. I thought I could use DSum but am having problems with it.
I've just used the toolbox to add a text box to the main form to calculate the sum of all payment amounts from the all trans table where the category is = pay. I've set the properties, control source as =DSum("[amt]","[all trans]","[cat = pay]") but I keep getting error.
I was then going to do the same for cat = adj and another text box to take one from the other.
Can anyone let me know where I'm going wrong?
Many thanks
I thought this would be simple but I'm finding it's not. I thought I could use DSum but am having problems with it.
I've just used the toolbox to add a text box to the main form to calculate the sum of all payment amounts from the all trans table where the category is = pay. I've set the properties, control source as =DSum("[amt]","[all trans]","[cat = pay]") but I keep getting error.
I was then going to do the same for cat = adj and another text box to take one from the other.
Can anyone let me know where I'm going wrong?
Many thanks