K
kateri4482
I have the following query:
SELECT TblDailyCodes.Code, TblDailyCodes.Classroom, TblDailyCodes.Date,
TblDailyCodes.Time, TblReportRun.OnDate, TblReportRun.OnTime
FROM TblDailyCodes, TblReportRun
WHERE (((TblDailyCodes.Time)>(TblReportRun.OnTime)));
I get no records, even though when I look at the two tables I should have
some as the time in TblDailyCodes IS greater than the time in TblReportRun on
some records. When I remove the WHERE clause I get all of the records, which
I don't want. What am I doing wrong? Thanks for any suggestions!
SELECT TblDailyCodes.Code, TblDailyCodes.Classroom, TblDailyCodes.Date,
TblDailyCodes.Time, TblReportRun.OnDate, TblReportRun.OnTime
FROM TblDailyCodes, TblReportRun
WHERE (((TblDailyCodes.Time)>(TblReportRun.OnTime)));
I get no records, even though when I look at the two tables I should have
some as the time in TblDailyCodes IS greater than the time in TblReportRun on
some records. When I remove the WHERE clause I get all of the records, which
I don't want. What am I doing wrong? Thanks for any suggestions!