Block exceptions

[razchip]

I have a table where I need to block a number of entries that can change. The table has hundreds of job numbers. I have another table with exception job numbers (EJN). I want the EJN's to be blocked in my query. Is there a way to do a lookup or vba code to block these EJN's from comming through, changes and to many to do a "not like" statement?

Thanks for the help.
Greg

 

[traingamer]

How about something like (replace field names and table names as appropriate):

Select ymt.* from [yourmaintable] ymt
where ymt.Jobnum Not IN 
(Select distinct ejn.Jobnum from [yourexceptiontable] ejb)

That assumes that your users only have table access from a form or a query that you provide to them - not direct table access.


Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[razchip]

Thanks, this worked just fine.

Thanks for the help.
Greg