Wayne, I can't post the db I'm working on so I made a small sample of what I'm trying to achieve. Of course this sample works so I'm not sure why my real db isn't working? At least I know that my SELECT statement works Thanks to you. I'll have to go through everything to see if I can figure out...