Using an sql algorithym?

[ian_bateman3]

Hello all
I wonder if anyone can help me with this..
I am building a piece of scheduling software for a small company.
I implemented an access database with the following tables:

Days (DayID, Day)

Hours (HourID,Time)

Shift (ShiftID, DayID, HourID)

StaffAvailability (AvailabilityID, staffID, ShiftID)

Staff (StaffID, Forename, Surname, JobID)

JobTitle (JobID, Title)

The table shift has 98 records in it, these are all the different shifts in a week (14 a day)

I am developing the software in vb6. I have built a vb6 application with the following forms.

FrmAddStaffMember
FrmEditStaffMember
FrmRemoveStaffMember
FrmMainMenu
FrmStaffAvailabllity
FrmStaffDetails
FrmStaffRota
FrmViewStaffDetails

I have managed to insert into and delete from the database using sql in the following forms: FrmAddStaffMember, FrmEditStaffMember, FrmRemoveStaffMember, FrmMainMenu, FrmStaffAvailabllity.

The form staff availablity consists of a series of 14 check boxes for each day so 98 in all. When the program is running the user selects availble working times for each meber of staff and adds the values in to StaffID and ShiftID

Now I need to generate a list of available employees for each shift and display it in a rota. I am not that sure how to do this, think it might be an algorithym or something and I was wondering if anyone could help?

I have attached the vb program and the database

Thanks

Ian