Query design help

[claudia_lovez_u]

I'm not sure how to do the following querys on my excel homework with a data the teacher gave me?

1. Show only two columns: Employee FName & Lname, where LName begins with B or H, ascending sort on LName.
2. Show only two columns: Employee FName & LName, excluding those records where the City ends with “o” or “n”. Sort ascending on FName. Hint: Use NOT, LIKE, Wildcard symbol, AND

Can anyone help me? thank you

[pbaldy]

What have you got so far?

[claudia_lovez_u]

well i already created the querys but I don't know how to sort it. I'm new to Access so this is confusing

What have you got so far?

[pbaldy]

In design view you should see a row titled "Sort". In SQL view, you'd add an ORDER BY clause.

[claudia_lovez_u]

I see it in design view but how would I make it to show the LNames begins with B or H?

[alansidman]

Do you want only names that begin with B or H?

If yes, then in your criteria, type Like B* or Like H*

[claudia_lovez_u]

Thanks a lot for the help! could you please help me with #2 also? I don't know how to do it if the city column is not suppoused to be shown in the query

[alansidman]

Look at this link for examples.

http://www.techonthenet.com/access/queries/like2007.php
You need to do your own homework. I didn't read the whole thread the first time.

[June7]

If you don't want the criteria field to show, unclick the 'Show' box in the query grid.

[claudia_lovez_u]

thank you so much! now I understand..!