How to find out and delete record if one person has more than 2 bookings within 3 months

[chihin098]

Hello i am new to access VBA
and i am now writing a access program to list out if one person has more than 2 bookings within 3months
if yes, then list out all the record of this case and delete the data in the database.
i have try to use query to do my task, but it was fail.
Can anyone teach me how to do that?
Thank you so much

[burrina]

Not without some basic information such as tables and field names! How about instead NOT allowing overbooking in the first place? Please provide details.

[chihin098]

I have been gave a task to improve the current access database program.
Every 6 months should have a booking for "large check"
if a person has made the "large check" booking
then a "small check" booking will auto generate.
However, in case if he doesnt follow the booking and come for "large check", or he has failed the "large check"
then, the "small check" booking should be canceled.(my program cannot do the cancel)
The person need to do the "large check" a few days later the orginal date of "Large check" date,
So, a new "small check" booking will automatic generate


so, my task is to write a program to find out and delete all these "small check" booking which should be cancelled(earlier one). i have "person_id" ,"large booking date" and "small booking date" for each row of record.
i am trying to write a program to check if in the coming 3 month, is there are more than 1 "small check" booking.
If yes, delete the earlier record of "small check"


i am new to VBA and i dont know how i can do it.
Sorry for my poor english...
and for the privacy reason, i cannot provide my access file here.