adding all #s in a field 1

[SpyPnch]

I am trying to do a simple query that just adds up all the numbers in a field and returns a total. Access keeps trying to group these numbers by rows so I cant figure out how to just get the total on one line

 

[HarleyQuinn]

Something like:

SELECT SUM(YourField) 
FROM YourTable

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.