Date Comparrison

[mrwelcam]

Hi, I have a table with the fields Starting_Date and Finishing_Date. I need to create a query that asks the user to input a date and if the date is in between the Starting_Date and Finishing_Date the necessary rows will be displayed.

This is what I have so far, but it doesn't work.

SELECT PATIENT.[First Name], PATIENT.[Last Name], PATIENT_ADMISSION.Starting_Admission_Date, PATIENT_ADMISSION.Finsihing_Admission_Date


FROM PATIENT INNER JOIN PATIENT_ADMISSION ON PATIENT.Patient_ID = PATIENT_ADMISSION.Patient_ID
WHERE (((PATIENT_ADMISSION.Starting_Admission_Date)>=[Please enter a date]) AND ((PATIENT_ADMISSION.Finsihing_Admission_Date)<=[Please enter a date]));

How do I make the [Please enter a date] value be used as a comparison for the two fields.

Cheers

Cam

[thhui]

The sign of comparision according to the logic is wrong.

The code should be:-

SELECT PATIENT.[First Name], PATIENT.[Last Name], PATIENT_ADMISSION.Starting_Admission_Date, PATIENT_ADMISSION.Finsihing_Admission_Date
FROM PATIENT INNER JOIN PATIENT_ADMISSION ON PATIENT.Patient_ID = PATIENT_ADMISSION.Patient_ID
WHERE (((PATIENT_ADMISSION.Starting_Admission_Date)<=[Enter Date]) AND ((PATIENT_ADMISSION.Finsihing_Admission_Date)>=[Enter Date]));