Hi,

I have a table as shown below

Field1
53
80
47
66
92

How can i write a query to retrieve the sum of all rows in column 'Field1'
Can any one of you please let me know. Thanks.

Make a query with the field you want. Then, on the menu bar you will see the Greek Letter E (I dont know what it's called). If you place your mouse over it, it will say "Totals". Click on that. You will see a new line added to the field called Total. Click on the drop down arrow and select Sum.