Select query limitations

[rrtpeds]

So here is my issue. I have one table full of employees 64 to be exact. then I have them electronically place schedule requests by choosing multilpe options for what kind of shift they are going to work. One of the codes is ED. I now want to be able to run a query that will allow me to see all the people and shifts being worked for Ed. Each day and night shift is seperately labled. EG sunday night shift is Sun. Sunday day sud1.

So I create a query choosing the names and then each day and place a criteria of Ed in the criteria box. However if i try and generate a query it will only pull records if all fo the days have ed. how can i write a statement that will only show people who have Ed written in these fields but not ed in all of the days.

thanks
Chris

 

[jwhite]

We would need to know your table structure before we could assist you. Sounds like your table structures need fixing, as your shifts should not be in multiple tables -- one table with a field to designate the shift type. Makes querying alot easier. Is your MDB small enough to be able to post a copy here (de-sensitize any confidential data)?