You can use the TopValues property to return a specified number of records or a percentage of records that meet the criteria that you specify. Setting this property is an easy way to show all fields without having to click the Show box in the query design grid for each field in the query. You can use the OutputAllFields property to show all fields in the query's underlying data source and in the field list of a form or report. You can use the DefaultView property to specify the opening view of a query. You can use the Description property to provide information about objects contained in the Database window, as well as about individual table or query fields.

The following table lists all the query properties and explains what each one is used for. To display the Query Properties, left-click in an empty space in the query design window. In some versions of Access, the property sheet will open and default to the 'Field List Properties'. To 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. This information is useful if you want to perform such tasks as: This article shows you how to modify query properties in Microsoft Access. This article applies only to a Microsoft Access database (.accdb and.

How to change odbc timeout in access 97