If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total per id in table
I have a simple database with one table that has the fields userID,
date, comments, votes. I need to figure out how to setup a query to list each id only once and also total up the number of votes that id hade for the previous month. The userID will have about 60 different values that can be in the table more than once. Each record will have one vote. During the month people will vote on people for whatever and I just want to be able to run a query and report to have a grand total for each userID. |
#3
|
|||
|
|||
John Vinson wrote in message . ..
On 18 Aug 2004 21:23:51 -0700, (colby) wrote: I have a simple database with one table that has the fields userID, date, comments, votes. I need to figure out how to setup a query to list each id only once and also total up the number of votes that id hade for the previous month. The userID will have about 60 different values that can be in the table more than once. Each record will have one vote. During the month people will vote on people for whatever and I just want to be able to run a query and report to have a grand total for each userID. A Totals query will do this. Create a Query based on your table, selecting the UserID and Votes fields (include the [Date] field - which should be renamed to something other than a reserved word, by the way - only if you need it for criteria to select a subset of the records). Change the Query to a Totals query by clicking the Greek Sigma icon (looks like a sideways M). Change the default Group By on Votes to Sum; if you included the date field, change its Group By to WHERE and put a criterion (such as Between DateSerial(Year(Date()), Month(Date()), 1) AND Date to get the votes for the current month). This will get your total vote count. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public Thanks alot John! I learned something new with the sigma icon, that is why I could not figure out the sum part. Again, Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using DLookup() to obtain a total from a group of records in a related table | Paul James | Running & Setting Up Queries | 5 | July 9th, 2004 02:00 AM |
Report totals Query Total Vs Table Total | Michael Noblet | Setting Up & Running Reports | 1 | May 25th, 2004 05:17 PM |
Cannot join 1:M table into M:M tables | Tom | Database Design | 4 | May 19th, 2004 10:16 PM |
Pivot Table column to column measurement | Mel | Worksheet Functions | 0 | April 12th, 2004 10:13 AM |
Pivot Table Data Fields Won't Total | Dave Y | Charts and Charting | 0 | March 4th, 2004 04:40 PM |