Query help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Query help

Author

Topic

C_H_I_L
Starting Member

9 Posts

Posted - 2005-05-13 : 07:49:33

Hi, i just found this Access part of the site. I have the folowing query, that run from a command button on a form. When the button is pressed it opens a query made withthe following code.

SELECT Attendance.Date, Count(Attendance.Attended) AS CountOfAttended, Student.StudentName
FROM Student INNER JOIN (Groups INNER JOIN (Classes INNER JOIN Attendance ON Classes.ClassID = Attendance.ClassID) ON Groups.GroupID = Attendance.GroupID) ON Student.StudentID = Attendance.StudentID
WHERE (((Attendance.Attended)=' absent'))
GROUP BY Attendance.Date, Student.StudentName, Student.StudentID
HAVING (((Student.StudentName)="Chris_Lynch") AND ((Student.StudentID)=[Forms]![Frm]![cboStudent]));

this code returns the number of absents for a student for each date.
So it will say something like chrislynch(studentname) 11/05/2005(date) 3(missed 3 classes )

What i want it to do is, have a query that will return a value if all the attended values are absent for one day?

I can try to explain it better if this don't help

Thanks
Chris Lynch

C_H_I_L
Starting Member

9 Posts

Posted - 2005-05-16 : 05:02:52

I take it that this isn't the right place to ask questions about SQL?

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-05-16 : 07:48:05

can you give us sample input data and sample (matching) expected.
Sometime's we're not great to conceptualise your problem....especially where there is a dragon of a boss breathing down our (unpaid sqlteam) necks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources