what is the difference between using a filter and query to find records?
A filter can be used to display all the data of a single table based on a specified condition. ... A query can be used to display selected data from one or more tables based on a specified condition or no condition at all. The result of the query can be saved for later use.