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 check box
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 like what you just saw
rate it at a comment subscribe to our
chilled
the freedom to learn
what you want when you want absolutely
free
GCF learn free.org