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 - 29 May 2008 21:20 GMT
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
>I am working an invite list.
>
[quoted text clipped - 16 lines]
>
> If this is too difficult a path, I am open to suggestions.