I am doing patient appointment booking program. The script that I'm trying to write now checks all the available appointments from the table appointments.

I am having this error on my program, Too few parameters. Expected 1.

Here is the sql statement.

idTrue = Request.QueryString("id")
dateTrue = Request.QueryString("dateSelect")
monthTrue = Request.QueryString("monthSelect")
empTrue = Request.QueryString("emp1")

strSQL = "SELECT staff.Name, staff.staffID, appointments.Date, appointments.Month, appointments.Time, appointments.appointment_booked, patientss.LoginID FROM (staff INNER JOIN appointments ON staff.staffID = appointments.staffID) INNER JOIN patientss ON staff.staffID = patientss.staffID WHERE (((appointments.Date)=" + dateTrue + ") AND (( appointments.Month)='" + monthTrue + "') AND ((appointments.appointment.booked)=No) AND ((patientss.LoginID)='" + idTrue + "'));"

rsSearch.Open strSQL, MyConn

I have got three tables with the following attributes.

Patientss(LoginID, staffID, appointmentID, Title, Last_name.....)
staff(staffID, Name, Job_title..)
appointments(appointmentID, staffID, Date, Time, Month, appointment_booked..)

CAN ANY TELL ME HOW TO SORT IT OUT.

I would check the format of the dateTrue value and make sure it is in a recognizable format. (e.g. m/d/yy, etc.)

Also this snippet for the date:

((appointments.Date)=" + dateTrue + ")

is missing the ' (single quotes) like:

((appointments.Date)='" + dateTrue + "')

Does your Date field keep only the date portion of a datetime value? If not, you can't simply compare it with "=" because for example 4/26/04 11:03PM <> 4/26/04.

Please check this page.
http://support.microsoft.com/default...b;en-us;216425

CAUSE
This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried.

You are missing something there.

_________________________
-Vijay G
Strive for Perfection