Help with Moving names

[Mcinsane]

Hey guys,

I have a table that has all my employees names in one column, and the next Rows, have Monday-Sunday, and checkboxes, indicating if they can work that day or not.

What i want to do is....Anyone who has Monday checkbox selected, i want there name moved to a table that i designated only for my Monday Workers.



And then the same for Tuesday - Sunday.

Is this possible, or just way to complicated?

Thank you in advance!

[RuralGuy]

You don't really want to move the name. You should just put the PrimaryKey of the Employee record in the other table. You may also want to review your table design for normalization. Repeating fields is a big red flag.