OK,
I got a load of textboxes on a form set out a bit like an excell sheet. I've got 15 columns and 8 rows and a seperate textbox. the bottom row is a sub total row and the single box is the grand total. Now, the subtotal boxes are summing up each column.
I'm currently doing this with:
=[TXT1a]+[TXT2a]+[TXT3a]+[TXT4a]+[TXT5a]+[TXT6a]+[TXT7a]
in the control source. But if one of the textboxes is left blank the subtotal isn't displayed. And even with values in all the boxes (which will never happen under normal use) it only shows the value when you click the subtotal box. But, thats not my main worry as long as i can add the boxes up even with some blank i'll manage
I got a load of textboxes on a form set out a bit like an excell sheet. I've got 15 columns and 8 rows and a seperate textbox. the bottom row is a sub total row and the single box is the grand total. Now, the subtotal boxes are summing up each column.
I'm currently doing this with:
=[TXT1a]+[TXT2a]+[TXT3a]+[TXT4a]+[TXT5a]+[TXT6a]+[TXT7a]
in the control source. But if one of the textboxes is left blank the subtotal isn't displayed. And even with values in all the boxes (which will never happen under normal use) it only shows the value when you click the subtotal box. But, thats not my main worry as long as i can add the boxes up even with some blank i'll manage
