Search results

Dear Popup Smurf and Missinglinq, I have no words but Thanks ! Thanks ! Thanks ! and just Thanks ! and I'll always be very grateful to both of you for taking interest in solving my problem. I did not anticipate that this problem could be fixed this fast coz I'd thought that there was some...

Hi, I have attached the db. I had created a db with just two tables y'day, one for main form and the other for the sub-form and used the sum() on the subform subfooter, it worked fine. But then I again recreated my db by copying the tables and recreated the main form and the sub form and tried...

That's right. Both share the same name. What difference could that make. The sum function should have worked, it's simple summing up all the records to be displayed in the subform footer but why is that not happenning.

=nz(Sum([Units])) I've even tried SUM([Units]) which should have worked but....

Hi Missinglinq, No, they are not calculated fields but bound forms to a table different from the table for the main form. Thanks in advance for any solutions.

Data Type is Number.

Hi Poppa Smurf, Appreciate your remedy... I've tried this formula b4 but no luck. But after I type this formula, the resultant #error is left aligned (any clue). I have a lot of rows/ records in my subform, it could run in 3 figures sometimes for one single record for the main form, but no...

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...