Avoid fully expanded names?

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

In a query, if I use the very nice feature of * to get all of the columns
from a table or query, and then specify a few columns for sorting and
criteria, those columns that were specified show up with the table name
attached. Is there any way to force their names back to just the column
name?

e.g.,
*
AddressTable

If this is all I have, then I see 'City' and 'State', etc., in my field
list.

But if I do this

* State
AddressTable AddressTable
ascending

then the field list contains '[AddressTable].[State]' instead of the nice
clean 'State'
 
Thanks! Would that everything were so clean!

MacDermott said:
Try removing the checkmark from the Show line under your State column.

HTH
- Turtle

Laurel said:
In a query, if I use the very nice feature of * to get all of the columns
from a table or query, and then specify a few columns for sorting and
criteria, those columns that were specified show up with the table name
attached. Is there any way to force their names back to just the column
name?

e.g.,
*
AddressTable

If this is all I have, then I see 'City' and 'State', etc., in my field
list.

But if I do this

* State
AddressTable AddressTable
ascending

then the field list contains '[AddressTable].[State]' instead of the nice
clean 'State'
Click to expand...
Click to expand...
 
Back
Top