how do I add totals in access

[Guest]

Urgently need help
I have various data in one of my form e.g
Book Name Price
Bamby £10
Maps £4
Access £20

I want to be able to calculate & view the total price on all items as there
are over 100 different title in the form.
does any one know any formula or how I can do so.

 

[Joseph Meehan]

Urgently need help
I have various data in one of my form e.g
Book Name Price
Bamby £10
Maps £4
Access £20

I want to be able to calculate & view the total price on all items as
there are over 100 different title in the form.
does any one know any formula or how I can do so.

Assuming you are using Access database, let's start with a description
of your table format and continue on what type of grouping do you want
totaled?

 

[Guest]

If you simply want to total the price field for all records in the form add a
text box to the form's footer with a ControlSource of:

=Sum([Price])

Ken Sheridan
Stafford, England