Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am doing a homework assignment and can't figure out how to show only
certain information. My book says to display customers from Boise, ID and
Portland OR but there are also Sparks NV and Bellevue WA. SO how would i
show only the two cites without showing all of them????
 
You would build a query and put your criteria in to tell Access which
records to pull. Have you built a query before? Have you used the
"criteria" to help restrict what shows?

In your example, you would do so but you are looking for two values.

Hope that helps without giving you the answer directly. Post back if you
need more of a hint.
 
Hi,

To show only certain information in a database there are two ways of doing it.

The first, IMHO the right way is with a query.
Click on the Queries tab of the object browser on the database window.
Double-click on the Create Query Using Wizard button.
At the first dialog box select the table in question and press the >> button.
Press Next twice.
At the top put a Title like BoiseAndPortlandQuery.
Click on the Modify the Query Design radio button.
Finish.

Now to modify your query.
Find the column with the City Name. In the criteria box put "Boise". Right
Below it in the next line (the Or line) put "Portland".

Assuming that there is also a State column, put "ID" in the criteria on the
same line as "Boise". Ditto with "OR" and "Portland".

Run the query using the red ! up in the menu bar. You should only get
records with the criteria that you requested. If it works right, save your
query by going to File, Save on the menus.

Tip. Normally you really don't need to put the double-quotes around the text
as I've shown above as Access usually guesses it right; however, there are
times where Access guesses badly. Therefore it's best to put double quotes
around text; # around dates and time; and just leave numbers like 1,2,3 alone.
----------------
I did mention two ways didn't I. Dang. Open up the table in datasheet view
where you see all the records.

On the toolbar go to Records, Filters, Filter by Form.

Under the City column, press the dropdown and find one of the cities that
you want. Go over the the State column and do the matching state.

Next go down to the Or tab at the bottom left of the window. Select the
other city/state pair.

Go to the toolbar and select Filter, Apply Filter.
 
Back
Top