Re: Using the SUM function

dr223

Registered User.
Local time
Today, 04:27
Joined
Nov 15, 2007
Messages
219
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..
 
Hi MStef,

Thnaks for the forward mdb. I did exactly as what is shown in the form. In the Form Footer I added a text box and in the control sourse put =Sum([Standard_fee]) but still it never shows up when I am in the design view.

The problem is that I can not view the text box when I am in the design view. I am sure the control source will be ok.

Thanks
 
Sorry when am in the Form view not Design view
 
You have got a DATASHEET view, change it in CONTINUOUS view.
 
When I set the dataset to continuos Forms the entire layout is unpleasant and data is all scattered around. I.e., all the rest of the subform is messy. However, the Total Amount was visible at the end of the form

Is there any other way I can still keep the format which i have formulated + the total amount.

Thank you
 
Also, in my subform I have other fields with lists, therefore the continuos form makes the full list displayed then it select the one I did select for the selective record. I dont want that to happen.

I want it to be displayed as before + the total amount is there any other way

Thanks
 
Send a short example of your mdb, (access 2000 or 2002).
 
Re: database

Hi Mstef,

The database is 2.67 MB size and here it only allows 100kb any ideas thanks
 

Users who are viewing this thread

Back
Top Bottom