Query column locations

N

Newbie

In the query I have Name, Address, PhoneNumber, City, and
State.

When I view the query the columns are located in a
different order. Is there a way to correct this - THANKS!
 
M

Martin Walke

Just specify the order of the fields in your select statement

"select field5, field2, field3, field1, field4 from table...."

HTH
Martin
 
B

Bob Richardson

Without seeing the entire query it's tough to know exactly what's happening.
I'm going to guess that you've included every field in a table, with the *
feature, and then you've included your specific fields in the order you
want. e.g.
Table.* Name Address etc.

If that's what you've done, put the Table.* "field" (of course it's many
fields) after the State field.
 
Top