complex query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that brings up vaction days per shift, but each shift has a
different criteria for the depts that are queried. The way it works now you
have to enter date then the shift. In the design mode there is a field for
dept. I have it Not in('4','5','6','7') So it brings up the vacations for
everyone except those in these depts. What i want is if i put in 1st shift i
want the above mention depts left out. For 2 shift i just want 4,5,6 left
out for 3rd shift i just want 5 &6 left out. I put all that in my query but
it does not work. Any ideas?


thanks
 
Hi,



.... WHERE CHOOSE( shift,
fieldName NOT IN('4', '5', '6', '7') ,
fieldName NOT IN('4', '5', '6'),
fieldName NOT IN('5', '6') )



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to make shift entry optional 6
vacation query 6
Can't seem to get rid of record from query 3
Query with most recent applicable criteria? 1
Trouble with large query 0
Using form to fill in query criteria not working 2
Can Vba workout if a selection is part of a group? 0
Crosstab Query based on 2 Combo Boxes. How? 17

Back
Top