First, I presumed you were running this sql in code, so I may have mis-directed you. Sorry if that's the case, but you can use the info anyway for the day you get around to doing that. Keep in mind that I expected you would read enough of the thread link I posted to grasp the idea. I did not consider the whole context of your sql statement, only part of it. I left it to you to try wrapping anything that needed to be delimited, but I see that you left the WHERE clause (and probably much of the rest of it) outside of the quotes. So that info relates to building sql in code, which you might want to keep on the back burner for now.
Based on your post #7, I have a different take on the issue.
Bound Column is 1 (Serial.ExamDate)
If the combo box bound column is 1 as you posted, the value being returned is Serial.SerialID not a date.
Serial.SerialID |
Serial.ExamDate |
column 1 |
column 2 |
Likely you are aware that a combo box column order is zero based, but 0 is the list index which is never visible. So I think you chose 1, thinking it is the second column after zero. This would also explain the lack of data - your date field is being passed the SerialID. Either re-arrange your field order by reversing the fields in the query OR change your reference to column(2) OR change the bound column to 2 (likely the easiest). If you specify the column in the sql, it would be like this, I think:
Code:
SELECT Student.StudentID, Student.LastName, Student.FirstNames, Student.Address, Student.City, Student.Prov, Student.PostalCode,
Student.HomePhone, Student.CellPhone, Student.DateofBirth, Exam.Attempt, Exam.ExamDate, Exam.ExamTime, Exam.Status FROM
Student INNER JOIN Exam ON Student.StudentID = Exam.StudentID WHERE (((Exam.ExamDate)=Forms!frmProvExamRoster.cboSerial.Column(2)))
ORDER BY Student.LastName, Student.FirstNames;
Your problem is not about being able to grasp this. Your problem is me not being on the same page. I'm beginning to think I'm spending too much time in this and another forum, which is making me a bit sloppy.