Query

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

Guest

Ok so I'm taking a class on line and have built a database and now I'm stuck
on queries. My assignment is to create a query that will include 4 fields
then I have to sort records in ascending order by city within a state. I can
not seem to find out how to do this. HELP!!!!!!!!
 
Have you created the query? Open it in design view, make sure you have
[State] and [City] selected as fields to display (along with the others-?4),
then use the "Sort" row to enter the sorting direction for the two fields.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Ladybug,

first off, (Good luck with your online class)

Now, to create a query using the wizard is fairly simple, select "queries"
from the object menus on the left side. Select "Create query by using wizard"

then just select the fields from your table that you want to use in your
query.

Once you have selected the fields and created the query, go back to your
database window, highlight the query you just created and select "open with
design view" In design view you will see the tables and you can sort them
using the drop down boxes provided.
 
Also, make sure that the [State] column is to the left of the [City] column -
sorting is done left to right if there is more than one column being sorted,
and sorting by state within city doesn't make sense! :-)

jk

Jeff said:
Have you created the query? Open it in design view, make sure you have
[State] and [City] selected as fields to display (along with the others-?4),
then use the "Sort" row to enter the sorting direction for the two fields. ...
My assignment is to create a query that will include 4 fields
then I have to sort records in ascending order by city within a state. I
can
not seem to find out how to do this. HELP!!!!!!!!
Click to expand...
Click to expand...
 
Back
Top