Hi,

I copied the sql code below from Access but having difficulty getting it 
to work in ASP.

SELECT Bookings.BookingID, StaffDetails1.StaffID, StaffDetails1.KnownAs, 
StaffDetails1.Surname, Services.Service, Bookings.StartDate, 
Bookings.StartTime, Bookings.EndDate, Bookings.EndTime, Bookings.SleepIn, 
Bookings.Status, Services.ReliefHourRate, (DateDiff("h",[StartTime],
[EndTime]))+(DateDiff("h",[StartDate],[EndDate])) AS Hours, [Hours]*
[ReliefHourRate] AS HoursCost, -[SleepIn]*25 AS SleepInCost, [SleepInCost]
+[HoursCost] AS TotalCost
FROM StaffDetails1 INNER JOIN (Services INNER JOIN Bookings ON 
Services.ServiceID = Bookings.ServiceID) ON StaffDetails1.StaffID = 
Bookings.StaffID
WHERE (((Services.Service)=[Name of service]) AND ((Bookings.StartDate) 
Like "*/" & [Month in 2 digits] & "/*" And (Bookings.StartDate) Like "*/" 
& "*/" & [Year in 4 digits]));

Any ideas?

Patrick