I'm trying to get a query to work...
SELECT tblUserSync.*, tblSyncSchoolInfo.*
INNER JOIN tblSyncSchoolInfo
ON tblUserSync.szSchoolID = tblSyncSchoolInfo.szSchoolID
WHERE tblUserSync.mntDate >= 09/12/2010;
The first part of the query works fine. The where clause doesn't seem to eliminate any records so it doesn't look like its working.