Skip to search results
PRODUCT
Office.com results
ORDER BY Clause
Article Show All Hide All Sorts a query's resulting records on a specified field or fields in ascending or descending order. Syntax SELECT fieldlist FROM table WHERE se...
Access 2010, Access 2007
Find records that have the most or least recent dates
Article To find most or least recent dates, use top values queries and totals queries. With a total query, use functions like Max or Min to return the highest or lowest...
Provided by: StevenT
Access 2010
Apply a filter to view select records in an Access database
Article Learn ways to filter data in Access to limit the records that are displayed in a query, form, or report.
Access 2010, Access 2007
Compare two tables and find only matching data
Article In this article, learn how to compare two tables by using joins, or by using a field as a criterion.
Access 2010
Make summary data easier to read by using a crosstab query
Article When you want to restructure summary data to make it easier to read and understand, consider using a crosstab query. A crosstab query calculates a sum, average,...
Access 2010, Access 2007
Make a query ask for input
Article Learn how to use parameters in an Access query to filter data using criteria values you supply when the query runs.
Access 2010
Search two tables for unmatched records
Article Show All Hide All Sometimes you want to compare two tables and identify records in one table that have no corresponding records in the other table. The easiest ...
Access 2010
Combine the results of several select queries by using a union query
Article When you want to review all of the data that is returned by several similar select queries together, as a combined set, use a union query. This article shows yo...
Access 2010
Find records in an Access database
Article This article describes several ways to find records in your database.
Access 2010
Use parameters to ask for input when running a query
Article Adding parameters to a query makes it ask for criteria so that it filters the results.
Access 2013
Use a union query to combine multiple queries into a single result
Article Get a combined view of multiple select queries with a union query.
Access 2013
Make summary data easier to read by using a crosstab query
Article Crosstab queries are useful for summarizing data, calculating statistics and then grouping the results.
Access 2013
Filter data in a desktop database
Article Learn ways to filter data in a desktop database to limit the records that are displayed in a query, form, or report.
Access 2013
Search two tables for unmatched records
Article Use the Find Unmatched Query in Access to compare two tables and identify records in one table that don't have corresponding records in the other table.
Access 2013
Didn't find what you were looking for?Search all of Office.com