even get a simple join to work.
I did several simple queries, each worked (including the all important date
query)
SELECT *
FROM classDates
WHERE classDates='10/11/2003' // does not work: "Data type mismatch in
criteria _expression_. "
WHERE classDates LIKE '10/11/2003' does work
WHERE classDates LIKE '#eventDay#' does work
My INNER JOIN:
SELECT classes.*, classDates.*
FROM classes INNER JOIN classDates ON classes.classID = ""> WHERE classDates.classDate LIKE '#EventDay#'
It doesn't work, even when using other fields than classDate.
(I'm using Access 2000)
Tables are below (complete)
CLASSDATES
ID (PK)
classID (FK)
classDay
classSession
classDate
classStart
classEnd
CLASSES
classID(PK)
classCategory
classSection
classCode
classTitle
classDescription
classNote
classTexts
classCost
classDeleted (Y/N) // allows me to recapture user deletes
I'm really at a loss as to why this doesn't work.
Gil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
