Sum of All Fields in A Column

[lpk294]

Hi...
I have a table called "Cash". In this table, as you already have reailsed, you enter the amount of cash...

So a table of 5 records may look like this for the cash column:

12
34
45
56
65

What i need is a query (or anything else that works) which works out the total of all the records in the cash column.

Any suggestions please?
Thanks a lot.

 

[ZmrAbdulla]

Place a textbox in the footer(Assuming your form is continues form)
Control Source =Sum([Cash])

________________________________________
Zameer Abdulla
Visit Me
A child may not be able to lift too much.
But it can certainly hold a marriage together