0
When you define a query that performs a calculation you must add a field?
Wiki User
∙ 10y ago
It is possible to do a simple calculation in a query without having any fields in it, but generally the whole point of queries is to work with data from tables, so there would be fields in them. If you wanted to do a calculation that did not involve any fields, then there would be no reason to use a database. You could use a spreadsheet or a calculator.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
cross-tab query?
performs calculations on the values in a field and displays the results in a datasheet
What gives you working space to type the calculation that you will use to produce a calculated field in query?
Criteria row Enjoy studying at icms =)
action query?
performs an action on the table on which it is based
How do you find average in query?
You need at least one numeric field in your query. Turn on the Total line in the query. Change the option under the numeric field to Average. When you run the query, you will get an average.
What are subqueries used for in a database?
A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.
When you double-click a field in a field list in Query Design View?
It will be added to the design grid when you double click a field list in Query Design View.
How do you get just the year number in a query in Microsoft Access 2010?
Use the YEAR function, which can extract the year of a date. If your field was DOB in the query you'd have MONTH(DOB) in the field row of the query.
When you run a query that contains a field Access evaluates the expression defined by the field and displays the resulting value in the query datasheet form or report?
a query can output to a form and a report. The norm is a report
In order to create a query using the Simple Query Wizard you choose the?
data source and the field name
The upper pane of the query window which displays the field lists for tables that are used in the query is the?
table area
How do you delete a field in Design view?
Whether you are designing a table or a query, select the field by clicking beside it in a table or above it in a query, so that it is highlighted. Then press the delete key.
What is the siyble of Wales?
Sorry, but your question makes no sense- what do you mean by 'siyble'? Please define, then I can answer your query.
