Create a Query That Uses Multiple Criteria in One Field
When you create a query that uses multiple criteria in one field for Access 2003, you restrict the number of search results that you will receive from that query. The multiple criteria can be either inclusive or exclusive depending on how the criteria are joined.

---

Examples of query criteria
When you want to limit the results of a query based on the values in a field, you use query criteria. A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. In this topic: * Introduction to query criteria * Criteria for Text, Memo, and Hyperlink fields * Criteria for Number, Currency, and AutoNumber fields * Criteria for Date/Time fields * Criteria for other fields

---

Create a Query in Microsoft Access Using Simple Equal To Criteria
This quick and easy tutorial will explain how to create a query using criteria. There are MANY types of criteria that can be used in a query, but for now we'll focus on a basic query to get started. We will first see how to retrieve customer data for customers that live in a particular state. Then, we will see how to expand this criteria to search for customers across multiple states at one time.

---

Using multivalued fields in queries
In Microsoft Office Access 2007, you can create a field that holds multiple values, such as a list of people to whom you have assigned an issue. Multivalued fields are appropriate for certain situations, such as when you use Office Access 2007 to work with information stored in a Microsoft Windows SharePoint Services 3.0 list, and that list contains a field that uses one of the multivalued field types available in Windows SharePoint Services 3.0. This article discusses multivalued fields and how to use them in queries. In this article * What is a multivalued field? * Introducing queries * Displaying a multivalued field in a query * Displaying the individual values in a multivalued field * Understanding the bound value and the display value in a lookup field * How to display the bound value in a query * Entering simple query criteria for a multivalued field * Searching for more than one value in a multivalued field * Understanding the impact of including a .Value field in the field list. * Counting, grouping and using other aggregate functions * Using an Append query with a multivalued field * Using an Update query with a multivalued field * Using a Delete query with a multivalued field

---

Filter Query Results from a Combo Box
You should be aware that you can limit the results of a database select query by using particular criteria. The article relating to Microsoft Access Database Query Basics gives a breakdown on applying simple query criteria. What if you are not too sure about what criteria applies to the particular field - wouldn't it be better to be able to choose this from a list rather than having the standard Microsoft Access input box appear...

---

Examples of query criteria
If you are interested in including only those records that match your criteria in a query, then specify one or more criteria at the time of designing the query.

---

Microsoft Office Access 2007: 13 Pages
Contents: Tables and Relationships, Using Related Tables, Types of relationships, Viewing the Relationship window, Adding a Table in the Relationships Window, Setting Referential Integrity, Queries, Using Queries and RecordSets, Using the Simple Query Wizard, Creating a Query in Design View, Opening a Query, Adding a Table to a Query, Running a Query, Sorting a Query, Adding Criteria to a Query, Using Comparison Operators, Using an OR Condition, Creating a Parameter Query, Creating a Calculated Field, Creating Aggregate/Function Query, Creating an Action Query, Using Multiple Tables in a Query. (PDF file, install Acrobat Reader to read this Microsoft Office Access 2007 tutorial)

---

The Query Lost My Records!
Nulls in Criteria: You wish to mail two different messages - one to your WA friends and another to those in other states. You create two queries: one where the Criteria line under State reads WA , and a second query where the Criteria line reads Not "WA" . You could think this would take care of all cases. It doesn't!

---

How to create a Microsoft Access Append query with criteria
A Microsoft Access append query can be used to add records to an existing database table. Prior to creating an append query, decide upon the two Microsoft Access tables that you would like to use. One table will contain the records you would like to add and the other table will be the table to which the records will be added. At the completion of this "how-to" will be a database table that has additional records added to it based upon specified criteria. Select the two database tables that will be included in the query. Ensure that the data types for the information in the corresponding tables are the same. For example, if the information in the date field is being added to a table, ensure that the field in the corresponding table is formatted for dates.

---

Sort Records Using Multiple Criteria
Are you trying to sort records using multiple criteria in Access 2003? This can be a confusing step if you have not already tried it. With just a few short and simple steps this article will show you how to sort records using multiple criteria in Access 2003 with ease.

---

Query Design Articles and Tutorials
Here you will find articles and tutorials relating to Microsoft Access query designs, from planning what tables and fields will be used to selecting criteria to be applied. There is also information on query optimization and using calculations within the query. Hopefully you will find something of interest, whether you need to limit results of the query by applying simple criteria to designing expressions to calculate data on the fly.

---

Specify criteria for a text field
Want to limit the results of your query based on the value of a text field? You can specify exact values that you want a query field to match, partial values to match, or a set of values, any one of which to match. You can also exclude results based on specified values. Watch this demo to see how to do it.

---

Delete a field
You can delete a field from a query or from a table. When you delete a field from a query, the field remains in the database, but is no longer used in the query. When you delete a field from a table, the field is deleted from the entire database. This topic provides an overview of the considerations and process of deleting fields, and gives steps for deleting a field from a query or a table.

---

MS-Access Paremeter Queries
Is it possible to create a parameter query, where if the parameter input box is left blank will return all of the records? This article details how, if you design your query using the following criteria, you will be able to query by either a specific value, or leave the parameter box empty to return all of the records: In the following example, we would like to add criteria to allow us to query for a Salesperson by region, but may also like to view all records as well.

---

Numeric Criteria Expressions
To specify numeric criteria for an operation, you supply a numeric value as part of the string expression that forms the criteria argument. Suppose that you are performing the DLookup function on an Employees table to find the last name of a particular employee, and you want to use a value from the EmployeeID field in the function's criteria argument.

---

Access 2002, Date Query
I am trying to find out how many days between two dates?? I have tried: in query design I have tried: (field: transaction date) (field: date case received) expression:[transaction date] - [date case received] what is the criteria supposed to be?

---

Use Multiple Fields in Criteria Expressions
Learn how to specify multiple fields in a criteria argument.

---

Multiple Fields in Criteria Expressions
Learn how you can specify multiple fields in a criteria argument.

---

Creating Microsoft Access Parameter Queries
Most of the queries that you will create in Microsoft Access will have pre entered criteria in the query design grid to select a group of records. This article will show you how to enable the database user to input criteria to be used by the query.

---

Extended DAvg()
The DAvg() function built into Access lets you get the average of a field in a table, and optionally specify criteria. This EAvg() function extends that functionality, so you can get the average of just the TOP values (or percentage) from the field. You can even specify a different field for sorting, e.g. to get the average of the 4 most recent values. Code to average a field in a table/query in Microsoft Access, with the option to count the TOP values. A replacement for DAvg().

---

Multiple Table Queries
Most of the queries you create in Microsoft Access will more that likely need to include the data from more than one table and you will have to join the tables in the query. The capability to join tables is the power of the relational database. As you know, in order to join database tables, they must have a field in common. The fields on which you join tables must be the same or compatible data types and they must contain the same kind of data, however they do not have to have the same field name (although they probably will). Occasionally, the two database tables that you want to bring the data from may not have a field in common and you will have to add another table to the query with the sole purpose of joining the tables.

---

Percentage Calculation-Forms
I have a field in query "Car_Value" then I want create a field (not in table/query) "Percent_15%" formatted 'number', and another field (not in table/query), "15%_OF_Car_Value". I want to calculate Percent_15% with Car_value, and show this value in "15%_OF_Car_Value". For some reason If I put in any number in percent_15% field it is disappering...

---

Calculated fields
A calculated field is a "virtual field" in a query. The field is virtual in the sense that it is not stored anywhere in the database. Instead, it is calculated dynamically when the query is used. Learning objectives: create a calculated field; understand why ACCESS add square; brackets around field names; understand the use of the ampersand operator (&). (pdf file, install Acrobat Reader to read this tutorial)

---

Dynamic queries using parameters
A parameter query is a query in which the criteria for selecting records are determined when the query is executed rather than when the query is designed. Learning objectives: understand the way in which parameters can be used to create flexible queries; prompt the user to enter parameter values; create a query whose results depend on a value on a form.

---

Add a subdatasheet
When two tables have one or more fields in common, you can embed the datasheet from one table in another. An embedded datasheet, which is called a subdatasheet, is useful when you want to view and edit related or joined (join: An association between a field in one table or query and a field of the same data type in another table or query. Joins tell the program how data is related. Records that don't match may be included or excluded, depending on the type of join.) data in a table or query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.). In this article * Introduction to subdatasheets * Open and close a subdatasheet * Add a subdatasheet

---

Create a Query Using More Than One Field
A single-field query in Microsoft Access 2003 extracts specific information from a database, such as “everybody with a birthday in November.” You can add other fields to this--say, making the query “everybody with a birthday on an even day in November who is under 60.” Here’s how to use more than one field in Access 2003 queries.

---

Build a search criteria form
A flexible search form provides several boxes where a user can enter criteria. An efficient search form creates the criteria from only those boxes where the user enters a value. This tutorial illustrates how to use: * Exact matches, * Partial matches (wildcards), * A range of values, * Delimiters for each field type, * Any combination of criteria, * A design that is easy to extend.

---

Parameter Query Criteria
I successfully created two tables. Products table and supplier table. I created a list box in the supplier table for products listed in the product table. I created a parameter query from the supplier table. My problem is the criteria. I would like to create a report from the parameter query. I would like this report to have a list box to select a product from the product table which would go into the criteria of the parameter query to form the report. I have been all over the help in access and cannot figure out how to do this. Your help would really be appreciated.

---

Guide to multivalued fields
This topic covers multivalued fields in Office Access 2007 and in Windows SharePoint Services, how to create a multivalued field and when to use one, and how to employ a multivalued field in a query. In this article: * What is a multivalued field? * Multivalued fields in Windows SharePoint Services * When to use a multivalued field * How to create a multivalued field * Using the Lookup Wizard * Modify the design of a multivalued field * How to employ a multivalued field in a query

---

MS Access 2000 parameter queries
Can anyone help me with a problem I'm having running a parameter query in Access 2000 ? I have a table that has a date/time field that I need to query, based on user input. I want the user to be able to select a date and retrieve all the items received on that day. Problem is if I use the notation =[Date?] in the criteria box in the query design view, it returns no results, even though there are records that should be returned. What is the correct syntax I should be using ? If anyone can point me in the direction of a tutorial I'd be grateful.

---

MS Access Date/Time ODBC issue
When you run a query based on a linked (attached) Microsoft SQL Server table that contains a Date/Time field, and the criteria for the Date/Time field contains a literal time value, Microsoft Access returns an empty result set.

---

Query That Uses More Than One Field
Queries allow you to display information in different ways. For example, suppose you have a table that contains complete addresses for your friends, but you just want a list of names and telephone numbers. You could create a two-field query to accomplish this. These instructuctions apply to MS Access 97.

---

Filter a query based on data entered in a text box
In Access 2003/XP/2000/97, I need to search for all Usernames containing 'ahm'. I want to create a form with a text box and a button. In the text box, I want to enter the search criteria and then click on the button to open the query displaying only the results where the Username field contains the value entered in the text box. How can I do this?

---

Access SQL: WHERE clause
This is one of a set of articles about Access SQL. This article describes how to write a WHERE clause, and uses examples to illustrate various techniques that you can use in a WHERE clause. In a SQL statement, the WHERE clause specifies criteria that field values must meet for the records that contain the values to be included in the query results. In this article * Limit results by using criteria * WHERE clause syntax * Use the WHERE clause to combine data sources

---

Require a value in a field
What do you want to do? *Set the Required property for a field to Yes *Create a non-null index for a field by using a data-definition query

---

Introduction to data types and field properties
This article provides an overview of data types and field properties, and includes a detailed data type reference section. This article also briefly explains Lookup fields (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.). This article does not discuss Lookup fields that allow multiple values.

---

Create a make table query
The information in this article explains how to create and run a make table query. You use a make table query when you need to copy the data in a table or archive data. If you need to change or update part of the data in an existing set of records, such as one or more fields, you can use an update query. If you need to add records (rows) to an existing table, you use an append query. What do you want to do? * Understand make table queries * Create a make table query * Learn more about query criteria and expressions * Stop Disabled mode from blocking a query

---

Basic Queries Using QBE
Learning objectives: Do queries contain any data? How do I create a query? What can I do with a query? How do I create a calculated field? Why does Access add square brackets around field names? What names should I give the queries I create? What does the ampersand operator (&) do? What is a non-updatable recordset? How do I tell whether a query results in a nonupdatable recordset? (pdf file, install Acrobat Reader to read this tutorial.)

---

How to Create a Query in Microsoft Access Using the AND and OR Criteria
This quick and easy tutorial will explain the differences between using the “AND” and “OR” syntax in a basic query.

---

Promote or demote a field, table, or query
Promoting a field creates a new group level immediately above the group level to which the field belongs. Demoting a field removes the group level to which the field belongs, and moves the field to the next lower group level. You can also promote all fields that belong to a table or query.

---