Sum Total of Numeric Field

[Char]

I am working an invite list.

I have 30 fields for each record. When using a query, I shorten it down to
Title, First Name, Last Name, Spouse, Dinner Invitation, Event Invitation and
Total Invitees.

For each record there is a Field: Total Invitees with a numeric value given
for the number of people in each family to be invited. A single person is 1,
a married couple is 2. (Children are given their own records, so there will
be no value higher than 2)

My question is this: How may I SUM total the numeric value in the Field:
Total Invitees and display it in a header or footer?

If this is too difficult a path, I am open to suggestions.

 

[Jeff Boyce]

Char

If you are working in a query, in query design view you can click the
"Totals" toolbar button to get a totals query. That's what it sounds like
you are describing.

By the way, a table with 30 fields per record may not be well-normalized.
So what? you ask...

Access is designed to do its best work with well-normalized relational
tables of data. If your data isn't, both you and Access will end up working
harder than you need to.

Regards

Jeff Boyce
Microsoft Office/Access MVP