SELECT classes.*, classDates.*
FROM classes INNER JOIN classDates ON classes.classID = ""> WHERE classDate=#createodbcdatetime(eventDay)#
I've tried several alternatives (via suggestions)
WHERE ((classDates.classDate)=# & [EventDay] & #);
WHERE ((classDates.classDate)="#" & [EventDay] & "#");
something, obviously is wrong, and I don't know what to look for.
Simple querys work so what gives. What next? I've checked and rechecked the
field and table names. What would you do?
I'm about ready to rebuild the tables and see what happens.
Gil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
