Calculating Total

[jimd1768]

Please excuse this very simplistic question but I cannot work out what to do.

I have a datasheet that has the fields:

Amount Due
Amount Overdue
Total

All I want to do is have the Total field adding the 2 amount fields.

Any help would be greatly appreciated.

Thank you

 

[Galaxiom]

Type this into the third textbox in design view:

=[AmountDue] + [AmountOverdue]

BYW Drop the spaces from your field and table names. It saves work and makes the code easier to read.

 

[jimd1768]

This doesn't seem to work. I am not sure where I am supposed to type this in design view.

Thanks

 

[vbaInet]

If you are adding up horizontally (i.e. for each record), then you create a text box and set the Control Source property to that.

If you want a total of all the records then you should be looking to make your form a Continuous form.

 

[JANR]

Type this into the third textbox in design view:

=[AmountDue] + [AmountOverdue]

This is to be used in a Unbound textbox in a FORM and not in a table!

This doesn't seem to work. I am not sure where I am supposed to type this in design view.

Which suggest that you tried it directly in the table, Access pre 2010 dosen't have triggers in tables.

JR