Column totals then showing them in a form

[Dannyc989]

Hi Folks,

I have a little problem that I hope you can help with:

I have a database which has a table for the quotes prepared, each record has a quote amount. In a query linked to that table I have the ability to get just a specific month view which shows all totals in that month. I want to calculate a grand total for the amounts shown in quote amount:

Record 1 : 100.00
Record 2 : 100.00
Record 3 : 50.00

Grand total : 250.00

Then I want to display this grand total on a form which is visable on a screen based in the office that has an auto refresh on it so after 2 minutes any new records added to the table will increase the grand total on the form on the screen.

Can anyone help please,

Many thanks in advanced.

Daniel

P.S. I have worked out how to do the totals bit, typically 5 mins after I posted this but now I need help getting this figure (I.e. 250.00) on a form without having to run the query and have it looking in the background

 

[Mihail]

Maybe by using DSum() ?????

 

[Dannyc989]

Could you please explain how and where to use this or another function

 

[Mihail]

Could you please explain how and where to use this or another function

As Control Source for a textbox.