Avoid fully expanded names?

[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'

 

[MacDermott]

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

HTH
- Turtle

 

[Laurel]

Thanks! Would that everything were so clean!

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

HTH
- Turtle

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'