Article ID: 304357 - Last Review: June 25, 2004 - Revision: 2.2 ACC2000: How to Modify Query Properties in Microsoft AccessThis article was previously published under Q304357 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb). For a Microsoft Access 2002 version of this article, see 304356 (http://support.microsoft.com/kb/304356/EN-US/ ) . SUMMARY
This article shows you how to modify query properties in Microsoft Access. This information is useful if you want to perform such tasks as:
MORE INFORMATIONQuery PropertiesTo view all the query properties, in Design view of any query, right-click in an empty space in the query design window, and then click Properties on the shortcut menu.The following table lists all the query properties and explains what each one is used for. Collapse this table
Field PropertiesTo see the field properties, in Design view of any query, right-click in a field in the query design grid, and then click Properties on the shortcut menu.Collapse this table
For additional information about lookup field properties, click the article number below to view the article in the Microsoft Knowledge Base: 304463
(http://support.microsoft.com/kb/304463/EN-US/
)
ACC2000: How to Add Lookup Fields in a Microsoft Access Table
REFERENCESFor more information about modifying query properties, click Microsoft Access Help on the
Help menu, type change query properties in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned. You can also view this information on the World Wide Web by clicking the Working with Queries topic on the Microsoft Access 2000 Help page at the following Microsoft Web site: Microsoft Access 2000 Help
(http://office.microsoft.com/en-us/access/FX100646941033.aspx)
For additional information about creating crosstab queries with multiple value fields, click the article number below
to view the article in the Microsoft Knowledge Base:
209143
(http://support.microsoft.com/kb/209143/EN-US/
)
ACC2000: Creating a Crosstab Query with Multiple Value Fields
For additional information about creating select queries, click the article number below
to view the article in the Microsoft Knowledge Base:
304361
(http://support.microsoft.com/kb/304361/EN-US/
)
ACC2000: How to Create a Select Query in Microsoft Access
For additional information about creating parameter queries, click the article number below
to view the article in the Microsoft Knowledge Base:
304353
(http://support.microsoft.com/kb/304353/EN-US/
)
ACC2000: How to Create a Parameter Query in Microsoft Access
For additional information about how to convert a select query to an action query, click the article number below
to view the article in the Microsoft Knowledge Base:
304355
(http://support.microsoft.com/kb/304355/EN-US/
)
ACC2000: How to Convert a Select Query to an Action Query
For additional information about modifying query properties, click the article number below
to view the article in the Microsoft Knowledge Base:
304357
(http://support.microsoft.com/kb/304357/EN-US/
)
ACC2000: How to Modify Query Properties in Microsoft Access
To download a sample Microsoft Access database that contains over 20 query examples, including the techniques described in these articles, see the following article in the Microsoft Knowledge Base:
207626
(http://support.microsoft.com/kb/207626/EN-US/
)
ACC2000: Access 2000 Sample Queries Available in Download Center
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
