The time to normalize your DB is at the start.
Then if that is not possible, then ASAP. You are only going to jump through hoops like this with your current structure. You are thinking with an excel head on and not an Access one.

In reality, you should have a subform with a record for each pill taken by a patient and that record records the number, frequency etc.

Your call?