answersLogoWhite

0

You can do it in the Design Grid in Design View or you can do it through SQL view if you know how to use SQL.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What task does the run query button perform in Access?

It enables you to run a query by clicking on the button. You can choose what query to run when you design it.


What does the mean in Microsoft Access?

The * symbol is a universal wildcard symbol. In the Access Query By Example Design Pane, the * represents all fields in the table or query.


How do you create update query in access?

If its 2007, Go to the "Create" tab, then "Query design" drag all the fields into the table at the bottom, Presto.


How do you view the results of a saved query in Microsoft Access?

Run the query. If in Design view you can do that by clicking on the red exclamation mark. If you go to the window and open the query directly, it will run.


Why do data appear many times on a query using access database?

It will depend on the design of your table and your query. If you have done something like brought the table in twice into the design of the query you will get multiple records. There are occasions when you would need to bring in the same table twice, but usually you don't. If you have it in twice it will list records multiple times. Go to the design view of the query and if you see the table there more than once, delete the extra copies of it, so that there is only one. Then design your query and it should be ok.


How do you find maximum and minimum of 5 number in ms access?

You can use the Max function and the Min function in a query to do it. They are both available when you use the Totals row in the query design grid.


The lower pane of the query window which displays the design of the query pane is?

It is known as the design grid.


What is a query grid?

the lower pane in Query Design View


Is a query grid the lower pane in query design view?

Yes it is.


What is a complex query in Microsoft access?

A select query with multiple criteria


What are two ways to create a query?

by using the query wizard or design view


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.