Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Filter by Selection is the fastest way to locate Records in your Table or Form that match your criteria. Open up to your Customers form and let's say I want to see how many restaurants and stores I have in California. Find an example of CA in the State field, highlight it and then go up to the Home ribbon to the Sort and Filter group, find the Selection button and drop it down. I have four options, Equals "CA", Does Not Equals "CA" Contains "CA" and Does Not Contain "CA". I'll click on Equals California (Equals "CA") and now I can see that I have two customers in California.
To bring all my records back I can see the Toggle Filter is highlighted so I'll click on it, and now all my records return. Let's highlight California again and go back to that Selection button and this time choose Does Not Equal "CA"-- now you can see all of your customers except those in California, and I'll click the Toggle Filter button to turn it off again. I can also filter by partial fields. In the Company field I'll double-click on the word Deli and then go to the Selection button, now my choices are Contains "Deli", Does Not Contain "Deli", Ends With "Deli" and Does Not End With "Deli".
I'll choose Contains "Deli" and I can see that I have three stores that have the word Deli in the name. Filter by Selection is just one of a variety of ways to use Access's Filtered tools. Please see your Access 2010 Essential Training to see more of them in action.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64672 Viewers
80 Video lessons · 124298 Viewers
52 Video lessons · 60237 Viewers
59 Video lessons · 46066 Viewers