Query column locations

  • Thread starter Thread starter Newbie
  • Start date Start date
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!
 
Just specify the order of the fields in your select statement

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

HTH
Martin
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate phone query 1
duplicate Phone search 4
Normalizing 4
Show every customer even if mobile in null 2
Show several values within one query cell 2
Linking Row Source in a subform 3
Manually storing Data to a field 8
Help with update query and unbound combobox 4

Back
Top