1. Registered User
Join Date
Apr 2003
Location
Uk
Posts
9

Hi

At the moment I have created a new layout (which is a list)
What I have been trying to do is it produce a field at the bottom in the footer which adds all the totals of the records into this field.

i,e in which record there is a total (£x.xx) so I what to see the sum of all the totals)

I have tried various difernt ways but it just wont do it

Its something simple I know

TA

Atu

2. Registered User
Join Date
Sep 2003
Location
Cincinnati, Oh USA
Posts
203

## Re: Adding Totals of records into one field

Use a "Summary" field and place it in the footer of your layout

Originally posted by stupot
Hi

At the moment I have created a new layout (which is a list)
What I have been trying to do is it produce a field at the bottom in the footer which adds all the totals of the records into this field.

i,e in which record there is a total (£x.xx) so I what to see the sum of all the totals)

I have tried various difernt ways but it just wont do it

Its something simple I know

TA

Atu

3. Registered User
Join Date
Apr 2003
Location
Uk
Posts
9

## Re: Adding Totals of records into one field

I knew it was something very simple

Thats great

Stu

4. Registered User
Join Date
Feb 2004
Posts
84

## Re: Adding Totals of records into one field

Originally posted by stupot
Hi

At the moment I have created a new layout (which is a list)
What I have been trying to do is it produce a field at the bottom in the footer which adds all the totals of the records into this field.

i,e in which record there is a total (£x.xx) so I what to see the sum of all the totals)

I have tried various difernt ways but it just wont do it

Its something simple I know

TA

Atu

Asummary field will work in many cases as mentioned from the other poster. There is also a more advanced method using the SUM calculation. The only catch is that you will need to create a realtionship to make the SUM calc work.

If you need help with this, let me know...

joe@svkingpen.com

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•