I have one table that has a list of schedules with the following columns:

AutoNumber, Date, Shift.  Example data looks like:

Autonumber        Date              Shift
1            1/2/08        7: 00AM – 4:00PM
2            1/2/08        7:00AM – 4:00PM
3            1/3/08        4:00PM – 12:00AM

I have another table of employees requesting the available shifts with the
following columns:

Date, Shift, Employee, DoubleDay, Reliability Rating.  Example data looks
like:

Date    Shift        Employee    Doubleday                Rating
1/2/08    7: 00AM – 4:00PM    John Doe    Sun        5%
1/2/08    7: 00AM – 4:00PM    Jane Doe    Wed        2%
1/2/08    7: 00AM – 4:00PM    Jose Doe    Sun        6%
1/3/08    4:00PM – 12:00AM    Jane Doe    Sat        10%

The object is to assign a schedule to the employee with the following logic:

1st logic – Request date is not the same as the Double Day gets the shift.
2nd logic – Rating with the lowest percentage gets the shift.

So looking at the above examples the result would be the following:

Shift Autonumber 1 will be given to Jane Doe.
Shift Autonumber 2 will be given to John Doe.
Shift Autonumber 3 will be given to Jane Doe.

Any help would be greatly appreciated