Order By twice?

[strbuxadct]

I am creating a database to store a wedding invite list. I am storing fname, lname, phone, street, city, state, zip.

Now i want to create a query that will return all the people in the list, i want to order it by people whos addresses are not in the database first in alphabetical order by last name, and then everyone who is in the the database with an address by alphabetical order by last name. Heres what i have so far:

SELECT fname, lname, phone, street
FROM tblGrooms
ORDER BY street, lname;

Now this will return exactly what i want, but it sorts the second half (the list of names that DO have addresses) by address NOT last name. How can i fix this?

Im sure this is a really simple fix and im just over looking it! Please help!

[MMcCarthy]

This question has been posted in the Articles section and is being moved to the Access forum.

ADMIN

[ADezii]

I am creating a database to store a wedding invite list. I am storing fname, lname, phone, street, city, state, zip.

Now i want to create a query that will return all the people in the list, i want to order it by people whos addresses are not in the database first in alphabetical order by last name, and then everyone who is in the the database with an address by alphabetical order by last name. Heres what i have so far:

SELECT fname, lname, phone, street
FROM tblGrooms
ORDER BY street, lname;

Now this will return exactly what i want, but it sorts the second half (the list of names that DO have addresses) by address NOT last name. How can i fix this?

Im sure this is a really simple fix and im just over looking it! Please help!

You could experiment with a UNION Query, something along the lines of:

SELECT tblEmployee.LastName, tblEmployee.FirstName, tblEmployee.PhoneNumber, tblEmployee.Address
FROM tblEmployee
WHERE tblEmployee.Address Is Null
 UNION SELECT tblEmployee.LastName, tblEmployee.FirstName, tblEmployee.PhoneNumber, tblEmployee.Address
FROM tblEmployee
WHERE tblEmployee.Address Is Not Null
ORDER BY tblEmployee.LastName;

[NeoPa]

I am creating a database to store a wedding invite list. I am storing fname, lname, phone, street, city, state, zip.

Now i want to create a query that will return all the people in the list, i want to order it by people whos addresses are not in the database first in alphabetical order by last name, and then everyone who is in the the database with an address by alphabetical order by last name. Heres what i have so far:

SELECT fname, lname, phone, street
FROM tblGrooms
ORDER BY street, lname;

Now this will return exactly what i want, but it sorts the second half (the list of names that DO have addresses) by address NOT last name. How can i fix this?

Im sure this is a really simple fix and im just over looking it! Please help!

You've only told us half the story.
How can you sort by the last name if the entry doesn't even exist in the database?
If you can express the question accurately, then I'm sure someone can help you with an answer. I suspect it won't be as complicated as using a UNION query in this case, but we can only guess if you don't share the question with us.