Access: How to Sort a Query if I used *

[gheyman]

I am querying two tables. I am trying to show all the fields from one of the tables, in my query results, by using the *.
I want to sort by one of the fields. is there a way to do this when you're using the * to identify the fields?

 

[ranman256]

select table1.* from table1,table2 sort table1.field

you can do this easily in query design.

 

[gheyman]

Thanks!

 

[james_lankford]

you can also do

sort by 3, 1

and that would sort by the 3rd field and then the 1st field

so if field 3 was the last name and field 1 was the first name you get it sorted by lastname, first name