We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
を使用すると、クエリ
を使用して、クエリ
を使用してクエリ
You create a query by using the following procedure.
次の手順を実行して、クエリを作成します。
You can sum a column of numbers in a query by using a type of function called an aggregate function.
集計関数という種類の関数を使用すると、クエリで列の数値を集計できます。
When forms that are based on this form template use the main data connection, InfoPath creates a query by using the data in the query fields.
Access queries are actually SQL statements that are created when you design a query by using the design grid in the Query window. The following table shows the Access action queries and data-definition queries and their corresponding SQL statements.
Create a query by using the Find Duplicates Wizard. By default, the query returns matching records only when the values in each field match character for character. If you need to find partial matches, you can use an expression in your query, or you can alter the Structured Query Language (SQL) code.
You can sum a column of numbers in a query by using a type of function called an aggregate function. Aggregate functions perform a calculation on a column of data and return a single value. Access provides a variety of aggregate functions, including Sum, Count, Avg (for computing averages), Min and Max. You sum data by adding the Sum function to your query, you count data by using the Count function, and so on.
集計関数という種類の関数を使用すると、クエリで列の数値を集計できます。集計関数は、データ列で計算を実行し、値を 1 つ返します。Access には、Sum、Count、Avg (平均を計算)、Min、Max など、さまざまな集計関数が用意されています。クエリに Sum 関数を追加してデータを合計したり、Count 関数を使用してデータをカウントしたりします。
To use this function, you must have established a connection with a data source by using SQLOpen, executed a query by using SQLExecQuery, and have the results of the query pending.
Create a query by using the Find Duplicates Wizard.
重複クエリ ウィザードを使用して、クエリを作成します。
You can get the SQL string for a query by using your database tool's SQL view. In Microsoft Access 97, you can view SQL for a query by opening the query in Design Mode and then choosing the View SQL item from the View menu.
When you design a form template that is based on a database, Microsoft Office InfoPath creates a main data source with groups that contain query fields and data fields and a query data connection as the main data connection for the form template. These fields and groups correspond to the way that data is stored in the tables in the database. Query fields contain the data that is entered by a user to limit the query results to records that match the data in the query fields. When a form based on this form template uses the main data connection, InfoPath creates a query by using the data in the query fields. InfoPath then sends the query through the query data connection. The database returns the results of the query back to the form through the query data connection. The results of the query are put into data fields, which can be edited through controls that are bound to these fields.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.