Greetings,

i have a DB with Appointments.

datestartand and dateend are fields containing the date from to.
The 2 fields are of the format Timestamp.

I am getting in the Application 2 dates (from - to) and need now to check if an appointment is allready boocked.

So how can this Querry be look like? What ever i try i get the wrong result

Code:
strSQL = "SELECT Count(*) FROM [Table] WHERE [datestart] >= " & _
             makeDBDatumSQL(dtEnde) & " and [dateend] <= " &        makeDBDatumSQL(dtStart) & " and lgppk = '" & strPK & "'"
many thanks for your help in advance