SUM

I have this TABLE, I want to automatically come up with SubTotal, as soon as
I enterThe Unit Cost and finally come up with the Total (sum of all figures
in SubTotal field)
Sale # Date Item Bought Quantity Unit Cost SubTotal Total
1 10/10/2004 Jean 2 120,000
2 23/10/2004 Handbag 1 100,000
3 29/10/2004 Snickers 1 250,000

How do I achieve this?
Please help

There is a very, very simple way to do this, so it can never go wrong.
Put the calculated fields into a query.

1. Remove the Total and SubTotal fields from your table.

2. Create a query into this table.

3. Type this into the Field row in query design:
SubTotal: CCur(Nz([Quantity] * [Unit Cost], 0))

4. Use this query as the source for your form.

Now in the Form Footer section of your form, add a text box with this
Control Source:
=Sum([SubTotal])
This shows the total.

For more information, see:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wantula" wrote in message
...
I have this TABLE, I want to automatically come up with SubTotal, as soon
as
I enterThe Unit Cost and finally come up with the Total (sum of all
figures
in SubTotal field)
Sale # Date Item Bought Quantity Unit Cost SubTotal Total
1 10/10/2004 Jean 2 120,000
2 23/10/2004 Handbag 1 100,000
3 29/10/2004 Snickers 1 250,000

How do I achieve this?
Please help