If you were going to work on coding what was explained in post #5, I could have guided you as you go along.
I'm sure that JLC can advise when he's next online.All; I created a sample database that seems to work with code and design flaws. It has to be something with the data. I'll have to find whats wrong. Please can someone review and make suggestions for a redesign and maybe I would get some time to redesign this flawed database. smh.