Re: Using the SUM function
Hallo,
This is a really basic question but am new to access. I have a subform which is built up of 3 fields, Payer_code, Session and FeeAmount (these are displayed in a straight line fashion) with drop down of various payer_codes, sessions and fee amounts.
What I want to do is to add a (TotalFee) field underneath the FeeAmount field only, so that I can use the Sum function to find the total FeeAmount.
I tried adding a text box on the Form footer section, but the field is not shown when I am in the Form view. I tried checking the Visible attribute it is set to YES.
What can I do different? Your help is indeed highly appreciated..
Hallo,
This is a really basic question but am new to access. I have a subform which is built up of 3 fields, Payer_code, Session and FeeAmount (these are displayed in a straight line fashion) with drop down of various payer_codes, sessions and fee amounts.
What I want to do is to add a (TotalFee) field underneath the FeeAmount field only, so that I can use the Sum function to find the total FeeAmount.
I tried adding a text box on the Form footer section, but the field is not shown when I am in the Form view. I tried checking the Visible attribute it is set to YES.
What can I do different? Your help is indeed highly appreciated..