แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

The Query Wizard helps you to design a database query. The saved query can be called later, either from the graphical user interface, or using the automatically created SQL language command.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Specifies the table to create the query, and specifies which fields you wish to include in the query.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Specifies the sorting order for the data records in your query.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Specifies the search conditions to filter the query.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Specifies whether to display all records of the query, or only the results of aggregate functions.

This page is only displayed when there are numerical fields in the query that allow the use of aggregate functions.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Specifies whether to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Specifies the conditions to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Assigns aliases to field names. Aliases are optional, and can provide more user-friendly names, which are displayed in place of field names. For example, an alias can be used when fields from different tables have the same name.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜

Enter a name of the query, and specify whether you want to display or to modify the query after the Wizard is finished.

แƒฃแƒ™แƒแƒœ

View the selections in the dialog made in the previous step. The current settings remain unchanged. This button can only be activated from page two on.

แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜

Click the Next button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes Create.

Finish

Applies all changes and closes the wizard.

แƒ’แƒแƒฃแƒฅแƒ›แƒ”แƒ‘แƒ

แƒ“แƒแƒฌแƒ™แƒแƒžแƒฃแƒœแƒ”แƒ‘แƒ แƒ’แƒแƒฃแƒฅแƒ›แƒ”แƒ‘แƒ-แƒ–แƒ” แƒฎแƒฃแƒ แƒแƒ•แƒก แƒ“แƒ˜แƒแƒšแƒแƒ’แƒก แƒงแƒแƒ•แƒ”แƒšแƒ’แƒ•แƒแƒ แƒ˜ แƒ“แƒแƒ›แƒแƒฎแƒกแƒแƒ•แƒ แƒ”แƒ‘แƒ˜แƒก แƒ’แƒแƒ แƒ”แƒจแƒ”.

แƒ›แƒแƒ—แƒฎแƒแƒ•แƒœแƒ”แƒ‘แƒ˜