Calculating a total

[jimd1768]

I know there is probably a very simple solution, but I do require some help from the experts please.

I want to add the 2 amounts in columns feesdue and feesoutstanding to give a total in "total".

All help is greatly appreciated. I have attached a screenshot to show what I mean.

Thanks

 

[PaulJR]

You need to create a query that displayes feesdue and feesoutstanding in the first and second column. In the field part of the third column, type in:

Total:[fessdue]+[feesoutstanding]

 

[boblarson]

To go with PaulJR's answer - You don't store this information in the table. You just use a query to get it when you need it. Remember, almost anywhere you use a table, you can use query.

 

[jimd1768]

Thank you very much. This worked.

Sorry for posting such a simple question.

 

[boblarson]

Total:[fessdue]+[feesoutstanding]

Oh, and you should use the NZ function to handle NULLS:

Total:Nz([feesdue],0)+Nz([feesoutstanding],0)

 

[Brianwarnock]

Thank you very much. This worked.

Sorry for posting such a simple question.

For the question asker there is no such thing as a simple question, if you don't know you don't know, end of.

Brian

 

[boblarson]

For the question asker there is no such thing as a simple question, if you don't know you don't know, end of.

Brian

Good point Brian. Not only with simple questions but I believe there is no stupid question IF you don't know the answer and you don't keep asking the same question over and over after getting the answer.

And that's what the forums are for - to answer questons in all difficulty ranges.

 

[jimd1768]

Oh, and you should use the NZ function to handle NULLS:

Total:Nz([feesdue],0)+Nz([feesoutstanding],0)

Thanks for this Bob. This does not return a currency value. What do I need to change?

 

[jimd1768]

Thanks all for your responses. No need to answer the above question, I have managed to figure something out myself!!!

 

[boblarson]

Thanks all for your responses. No need to answer the above question, I have managed to figure something out myself!!!

Did it involve something like:

Total:FormatCurrency(Nz([feesdue],0)+Nz([feesoutstanding],0),2)

 

[pkstormy]

To go with PaulJR's answer - You don't store this information in the table. You just use a query to get it when you need it. Remember, almost anywhere you use a table, you can use query.

This is not a hard-fast rule though! In accounting type programs this is often done. In most other types of programs, it's not. For example, summing/averaging/etc... on certain calculated type fields can sometimes become more difficult in the design of the program where it's easier to save the calculated value. Bob is correct for most situations such as yours but it shouldn't be taken as something you 'never' do. It's something you 'typically' don't do.