Goodwill Community Foundation creating
opportunities for a better life
I'm working on a query that shows us a
list of our bakery's customers who live
outside the city limits and there are a
couple of things that I'm going to do to
make the results easier to read sorting
the results and hiding the fields that
we don't need to see right now I'm in
datasheet view so I'll need to switch to
design view and there are two ways of
doing that you can either go to the view
drop-down arrow and select design view
or in the bottom right corner you can
click the icon on the far right
in the data grid there is a sort row
which is currently empty to add a sort
you can just click on the cell for the
field that you want to sort and then
click the drop down arrow to choose a
sort option and now our results will be
sorted alphabetically by city you can
also do a multi-level sort by just
adding a sort to another field a
multi-level sort will always work from
left to right so this is going to sort
first by city and then within each city
it will sort by zip code if we wanted it
to sort by zip code first then we would
have to change the ordering of the
columns and you can do that by clicking
at the top of a column and dragging it
to the left or the right
so this would sort first by zip code and
then by city but that's not what I want
so I'm just going to leave it where it
was
below the sort road there is a checkbox
for each field and you can uncheck a box
to hide the field in the results we're
using the phone number field to filter
our results but we don't actually need
to see the phone numbers so I'll uncheck
this and I'm also going to hide the ID
field and this is really just a way of
making the results easier to read by
reducing the amount of information that
you have to look at
now we can run the query again and you
can see that our results are sorted by
city and within each city they're sorted
by zip code and the phone number and ID
fields are hidden so we can just focus
on the names and addresses