I've tried two variations on the same query: one places
quotes round the date, and the other does not (the date is a
date/time field in an Access database).
I am getting this error: "Too few parameters. Expected 1."
Here are the queries in question.
SELECT class_enrollment
FROM tbl_class_enrollment
WHERE class_id = 840 AND section = '07409'
AND enrollment_date = 5/10/2004
SELECT class_enrollment
FROM tbl_class_enrollment
WHERE class_id = 840 AND section = '07409'
AND enrollment_date = '5/10/2004'
I've been working on this off and on for a couple of days
and I don't understand what's wrong. Any tips or pointers as
to *why* this isn't working would be greatly appreciated.
Online tutorials don't devote much time to date/time formats.
Thanks,
--
Austin
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
