Calculated Fields

[red_101au]

Hi all


New to the forum long time user.

I am having trouble getting my head around this one.

I have a table with calculated fields and that works fine.

what I am trying to do is get the values from the totals (sum value) at the bottom of each column to display in a textbox / list box or whatever on the form.
I am not even sure if this is possible so I am asking for any ideas or suggestions to manage this

I have attached images to try and show

Thanks

[Welshgasman]

Use DSum()
Use a union query that sums those fields with your data.
Use a recordset for a query that sums those values.

Option 1 and 3, use separate controls in the footer of the form.

[red_101au]

Thank you Welshgasman
This did the trick
The system is up and running very well
I still am not sure how to get the grand total
ie: the sum of the 4 distances
but im sure I will figure this out
however any further advice would be welcome

thanks again

[Welshgasman]

Well what method have you used for the totals. Summing them all together should not be difficult?

[red_101au]

Hi Welsh

To get the text boxes to display i used the "DSum" with the (relevant field) in each box's control source

=DSum("North","Distances_qry","Date<# 10/5/2023#").....

each being individual total

I still need to add these together to get Total kms

Thanks to you I got this far

[red_101au]

Hi Welsh

To get the text boxes to display i used the "DSum" with the (relevant field) in each box's control source

=DSum("North","Distances_qry","Date<# 10/5/2023#").....

each being individual total

I still need to add these together to get Total kms

Thanks to you I got this far

[Welshgasman]

So total is control + control + control + ..... etc?

[red_101au]

Hi again Welsh
Appreciate the time mate

I have tried this with several variations but each returns and error.

I believe there are too many parameters for the equation.

[Bob Fitz]

You don't need DSum(), just

=[North]+[South]+[Hills]+[Locals]

as the control source, as Welshgasman instructed in post #7