Showing posts with label Filters. Show all posts
Showing posts with label Filters. Show all posts
Sunday, October 17, 2010
Using parameters with queries and reports
"Using parameters with queries and reports - Access - Microsoft Office" ( http://bit.ly/cGEVmI )
Saturday, October 16, 2010
Access Query and Filter Criteria
From http://www.fontstuff.com/access/acctut06.htm
"When constructing a query or a filter, you need to tell Access what to look for in each field. You do this by defining criteria - typing something (an "expression") into the Criteria cell of the query or filter grid. If you do not define any criteria for a particular field, Access assumes that you are applying no constraints and will display everything it has. This means that you only have to define criteria for those fields you are interested in..."
This tutorial is arranged in the following sections:
"When constructing a query or a filter, you need to tell Access what to look for in each field. You do this by defining criteria - typing something (an "expression") into the Criteria cell of the query or filter grid. If you do not define any criteria for a particular field, Access assumes that you are applying no constraints and will display everything it has. This means that you only have to define criteria for those fields you are interested in..."
This tutorial is arranged in the following sections:
- Matching Text
- Using Wildcards
- Working with Numbers
- Working with Dates
- Excluding Things
- Finding Empty Fields
Subscribe to:
Posts (Atom)