Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2008

Tip: Looking for answers? Try searching our database.

Sum Total of Numeric Field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Char - 29 May 2008 20:46 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.