troubleshooting Question

How can I set my Access Query up to filter out specific records

Avatar of Dustin Stanley
Dustin Stanley asked on
Microsoft AccessVBA
13 Comments4 Solutions124 ViewsLast Modified:
I have 2 tables.

SKUs
SkuRestrictions


Skus are products and SkuRestrictions are restrictions on a product.
A Sku can have multiple Sku Restrictions.

I need my query to remove the records of Skus with the SkuRestrictionsID of 3,4,5,13,16, or 18
Now my query does a good job of removing the exact records with these exact SkuRestrictionsID

BUT.....

Lets say a SkuID of 3381 has SkuRestrictionsID of 2 , 5 ,16 , and 20
The 5 and 16 will be removed but I need all of them removed from the results of SkuID 3381

How can I do this??? Thanks!
SOLUTION
Join our community to see this answer!
Unlock 4 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros