What is the difference between and and or in access

You should just always use AND. Access I ran a query to match credit card numbers using only the last 4 numbers. Have to do a join to see if the card's last numbers and the employee number don't exist, then I know it's a new card to add to the DB.

As mellamokb said, you want AND. See stackoverflow. Damn, my edits suck today Add a comment. Active Oldest Votes. To see the differences in action, start with this as table WeinerDog. Improve this answer. HansUp HansUp 93k 11 11 gold badges 69 69 silver badges bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. Article Contributed By :. Easy Normal Medium Hard Expert. Writing code in comment? Please use ide. Load Comments. What's New. Most popular in Computer Networks. Most visited in Difference Between. We use cookies to ensure you have the best browsing experience on our website.

You may use logical AND within a single Criteria expression. A logical OR implies mutually exclusive criteria. But a Project cannot be both Mars and Venus , it is either one or the other. As an alternative to using Criteria rows to create logical OR conditions, you may create them within the same row:.