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

 

[jdraw]

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

Is it safe to assume you have a query based on a table? If so,
then let's say the table involved is "MyTable", and that it has fields
[Amount Due] and [Amount Overdue].

The query then is

Select
[Amount Due], [Amount Overdue], [Amount_Due] +[Amount_Overdue] as MyTotal
FROM MyTable

However, you should not be using spaces in your field names, it leads to many issues such as having to reference fields using square brackets
Hence the [Amount Overdue] etc.