hi there, i'm just new in using MS access and i'm trying to create a simple database for e-visa project. i have 2 tables tbl_receivedvisa and tbl_issuedvisa.
i put the 2 tables in one form without using any query. tbl_receivedvisa is the main form and tbl_issuedvisa is the subform. below are the contents of each table.
tbl_receivedvisa
1. visa_no
2. visa_title
3. total_receivedvisa
4. utilized_visa
5. remaining_visa
tbl_issuedvisa
1. visa_no
2. visa_title
3. issued_visa
my objective here now is to calculate (get the sum) of all issued visa in the subform.
i've already tried putting unbound text [txttotal] in the form footer =Sum([issued_visa]) and other unbound text in the main form =[sfrmvisa_issued].[Form]![txttotal] but i still didn't get the correct result and i'm getting #error instead.
Hope you can help me with this issue. thanks in advance
i put the 2 tables in one form without using any query. tbl_receivedvisa is the main form and tbl_issuedvisa is the subform. below are the contents of each table.
tbl_receivedvisa
1. visa_no
2. visa_title
3. total_receivedvisa
4. utilized_visa
5. remaining_visa
tbl_issuedvisa
1. visa_no
2. visa_title
3. issued_visa
my objective here now is to calculate (get the sum) of all issued visa in the subform.
i've already tried putting unbound text [txttotal] in the form footer =Sum([issued_visa]) and other unbound text in the main form =[sfrmvisa_issued].[Form]![txttotal] but i still didn't get the correct result and i'm getting #error instead.
Hope you can help me with this issue. thanks in advance