0
You use AND in a query to ensure more than one criteria are met in order for the records to be met. So if you have more than one condition and you want them all to be met, you would use an AND. You would use OR if only some of the conditions need to be met or there are several options on the same field.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Which is the primary advantage of creating a new query based on an existing query?
It saves time if your new query uses the same fields as the existing query.
How to change a field to Uppercase in a query?
Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.
What is a nested query?
It is a query inside another query. Sometimes we might use one query to reduce down the amount of data to go through and then use another query based on the output of that query to get what you want. The first query is inside or nested in the first query.
What query do you use to extract data from two tables?
You would use a JOIN query for this.
Use query in a sentence?
He was very query in the middle of the crowd.
Who would use a query?
Just about anyone who will use access will need to use a query (interrogated the data) at some point
Use the word query in a sentence?
I'm hard-pressed to elucidate an answer to your query. Every query has more than one answer. My results of my research do not definitively resolve your query. Is that the finest query you could devise on the subject?
How can you use query in a sentence?
quarry
Which query language will use in MS Access to maintain database?
It uses a version of SQL. (Structured Query Language).
Can you use query language to extrapolate information from a database?
Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.
What are the steps in creating a report in a database?
Steps involve in creating report. 1. Open the database window (F11) and click on the Report tab. * 2. Click New. A dialog box appears. * 3. Choose between Columnar and Tabular. * 4. Select the table or query that you want to use for your report. * 5. Click OK. * ** 6. Repeat the first two steps above. ** 7. When the dialog box appears, click Design View. ** 8. Select the table or query that you intend to use. ** 9. Click OK. *
What type of query that retrieves data from one or more tables and makes it available for use in the format of a datasheet is a what Query?
select
