dumb sum question

[steallan]

Hi

How do you add up all the values in a column in a query?

 

[ColinEssex]

You use a report or a form

Col

 

[steallan]

what form function should i use?

thx

 

[maxmangion]

you can use a dsum if you want to do that at form/report level.

 

[steallan]

???????????

apparently i cant do it in the query?

I have no idea what or where to write something to add up all the numbers in a column that i have in a query.

Whats the easiest way?

I cant export it to excel as the query has 200000 records

thx

 

[maxmangion]

in your query design view click on the Σ symbol to create a new Total row, then under the field which you want to total, choose Sum.

 

[Brianwarnock]

Why can't you use a Totals query?

Brian

 

[steallan]

i did that i couldnt get it to work????

anyway i've done it using the query wizard,

thanks

 

[maxmangion]

if you want try uploading a sample of your database (without sensitive data), and maybe someone, will see what's wrong with your Total Query.

 

[steallan]

how do you make a totals query??

i thought i had it but my i dont, i really really dont.

 

[steallan]

Hold on I do have it! YAY!

 

[Brianwarnock]

On that happy note I'll sign off and go home to watch the match.

Brian