Hi Everyone,
I am not an IT guy, I have designed an access database for inventory and sales details for some analysis and reporting. I have a subform within a form, but the problem is that when I want to calculate the sum total of all values for the rows/ records for the subform in the subform footer, it gives an #error message in the those unbound textboxes.
I have three columns to be summed up, viz., Units, BankedAmt & OtherAmt (through debit/ credit cards) which are bound forms. The number of records in one single entry (main form) could run into three figures (for subform). I have two more columns after these three columns for TotalAmt (Banked Amt – Other Amt) and CostperUnit (TotalAmt / Units), the results of which are displayed correctly on each record in subform.
However, the problem is that I cannot sum total all the units/ BankedAmt and OtherAmt in the subfooter of the subform for confirming the total of each Bank receipt which is my one single transaction for the main form (when I use Sum/Agg).
I’ve even tried a combination of some formulas after checking on the net but just cannot get the result of sum of all units.
I am novice in creating an access database though I have used the applications some years back. Help in this regard would be really appreciated coz I want to display the total for that single transaction for the main as the details are captured in the subform and I want the totals on the subform footer only to know that all the details are captured correctly.
I guess that has nothing to do with the last row which is by default blank and has null values but that is normal I suppose. I use access 2003 SP3.
In anticipation of some early response.
I am not an IT guy, I have designed an access database for inventory and sales details for some analysis and reporting. I have a subform within a form, but the problem is that when I want to calculate the sum total of all values for the rows/ records for the subform in the subform footer, it gives an #error message in the those unbound textboxes.
I have three columns to be summed up, viz., Units, BankedAmt & OtherAmt (through debit/ credit cards) which are bound forms. The number of records in one single entry (main form) could run into three figures (for subform). I have two more columns after these three columns for TotalAmt (Banked Amt – Other Amt) and CostperUnit (TotalAmt / Units), the results of which are displayed correctly on each record in subform.
However, the problem is that I cannot sum total all the units/ BankedAmt and OtherAmt in the subfooter of the subform for confirming the total of each Bank receipt which is my one single transaction for the main form (when I use Sum/Agg).
I’ve even tried a combination of some formulas after checking on the net but just cannot get the result of sum of all units.
I am novice in creating an access database though I have used the applications some years back. Help in this regard would be really appreciated coz I want to display the total for that single transaction for the main as the details are captured in the subform and I want the totals on the subform footer only to know that all the details are captured correctly.
I guess that has nothing to do with the last row which is by default blank and has null values but that is normal I suppose. I use access 2003 SP3.
In anticipation of some early response.