SQL required for delete

[Neil]

Hello

I have an access database table which contains the fields 'room',
'datebooked' and 'lesson' amongst others.

I want to be able to do the following delete, for example :

Delete all bookings in room B4 on every Thursday lesson 4.

Can this be done in a single SQL statement or will I have to create a
recordset containing all the bookings in room B4, lesson 4 and then check
each record one by one to see if it is a Thursday? (ie using
if(weekdayname(weekday(datebooked)))="Thursday" then delete record etc)

I am using ASP VBscript
Thanks for any help.
Neil

[pietlinden]

DELETE
FROM bookings
WHERE ((Room='B4'
AND Lesson=4
AND (Weekday([somedate]))=5));

[Neil]

Thanks for that pietlinden!

<pi********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

DELETE
FROM bookings
WHERE ((Room='B4'
AND Lesson=4
AND (Weekday([somedate]))=5));