Question

![alt text][1]

[1]: http://C:Documents and SettingsAdministratorMy DocumentsMy PicturesAshampoo Magical Snap 2Magical Snap - 2009.11.16 23.07 - 003.jpg

In referring to the picture there are several entries where the same Student ID repeats. Where this happens I d like to combine the money owed by totaling any multiple entries under one Student ID. What do I need to add to the code below to accomplish this, please? I am using Access 2007 & the code below is the SQL view that is responsible for producing the pictured table. Thnaks, in advance, for the help!!!

SELECT Students.[Student ID], Students.[Last Name], Students.[Dorm Addess], [Number of Hours]*[Price Per Hour] AS [Money Owed]
FROM Students INNER JOIN ([Price List and Job Description] INNER JOIN Visits ON [Price List and Job Description].[Job ID] = Visits.[Job ID]) ON Students.[Student ID] = Visits.[Student ID];

Answer 1

Well, if i understand correcly you need a SUM and GROUP BY to achieve this.

Something like this

SELECT  Students.[Student ID], 
        Students.[Last Name], 
        Students.[Dorm Addess], 
        SUM([Number of Hours]*[Price Per Hour]) AS [Money Owed]
FROM    Students INNER JOIN 
        ([Price List and Job Description] INNER JOIN 
        Visits ON [Price List and Job Description].[Job ID] = Visits.[Job ID]) ON Students.[Student ID] = Visits.[Student ID]
GROUP BY Students.[Student ID], 
        Students.[Last Name], 
        Students.[Dorm Addess]

Answer 2

the intarwebs don t have access to your C:Documents and Settings, nobody sees your jpeg

友情链接