Results are false null

[mdavison]

I have a schedule table with anAutocount, a date and a class code. Dual
primary is AutoCountID and the Date, so that I can schedule more than one
class per date.I have 3 classes in the table for October 6. In a query to
show the list of classes on a parameter on date [Enter date], when I enter
10/6/06 (the same way I enter the classes when I schedule them) I am getting
NULL. When I remove the parameter criteria - my results are missing 620
records from the original table!!
How on earth does this happen??

 

[Guest]

Post your SQL statement.

 

[mdavison]

Here is SQL:

SELECT Schedule.Date, Schedule.ClassCode, Classes.ClassName
FROM AttendanceCodes INNER JOIN (Classes INNER JOIN (Schedule INNER JOIN
Attendance ON Schedule.Date = Attendance.DATE) ON (Classes.ClassCode =
Schedule.ClassCode) AND (Classes.ClassCode = Attendance.ClassCode)) ON
AttendanceCodes.AttCode = Attendance.AttCode;

(All the Classes table does is store the class code, class name and
description of topic covered.)