I have a scheduling database problem. The database table contains employees, dates, start times, and completion times.

However... I need the start times to synch up with specific slots.
  8-10, 10-12, 12-2, 2-4, and 4-6. And insert this data into a viewing table.

If the start time and is within the slots, and the end time is within the slots, I would like the slots to be updated for each employee. If not.. I would like the slots to stay empty.

If there an easy way of doing this?

This is the format...

employee1 8-10 empty
employee1 10-12 empty
employee1 12-2 busy... customer info
employee1 2-4 busy... customer info
employee1 4-6 empty

employee2 8-10 busy customer info
employee2 10-12 busy customer info
employee2 12-2 busy another customer info
employee2 2-4 empty
employee2 4-6 busy still another customer info

What would be an easy way of doing this without programming a hundred for loops, and if then statement.

Regards,


Marc Noon

Coding is a game. Live it, love it, break it, run it.

__________________
Marc Noon

Coding is a game. Live it, love it, break it, run it.

It seems to me that you don't want to store all these empty slots in a table. Perhaps you want to make a junction table and give an employee an assignment, like:

tblEmployee
EmpID
FirstName
LastName
SSN
etc

tblSlots
SlotID
SlotTime

tblSlotDesc
SlotDescID
SlotDesc

tblJunction
AssignmentID
FK tblEmployee
FK tblSlots
FK tblSlotDesc

Then just do a query and make a report. In the report, make room for all your slots. The most code you would need would be on the Reports Detail On Format Event like:

If IsNull(Me.SlotTime) Then
   Me.SlotTime = "Empty"
End If

Use the report instead of your "viewing table."

HTH


mmcdonal

What exactly would the query look like. I was not able to get your solution to work. I thought this was going to be a simple problem, but it has become a chore.

I think I need a table b/c I need to select a row or rows and update the data to correspond to the update.

So far my solution is a Kludge of lstBoxes and for next loops.

Regards,

Marc Noon

Marc Noon

Coding is a game. Live it, love it, break it, run it.