Changing field names when using make-table query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble figuring out the correct way to ask this question...

Is there any way to make it so that, when you bring data in from a different
table (with a make-table) query, the field names can be (configured to be)
something other than what they were named in the previous table?

Like, if I'm getting a "page numbers" field from one table, but on the table
I'm creating with the query, I want that field to be named "item location."
Is the only way to do this to rename the field after the table is made? I
ask because it would be nice to not have to rename fields so often, for
routine operations.
 
You can provide a different name by setting your field to something like:
ItemLocation:[Page Numbers]
 
thanks much!

Duane Hookom said:
You can provide a different name by setting your field to something like:
ItemLocation:[Page Numbers]

--
Duane Hookom
MS Access MVP
--

ExcessAccess said:
I'm having trouble figuring out the correct way to ask this question...

Is there any way to make it so that, when you bring data in from a
different
table (with a make-table) query, the field names can be (configured to be)
something other than what they were named in the previous table?

Like, if I'm getting a "page numbers" field from one table, but on the
table
I'm creating with the query, I want that field to be named "item
location."
Is the only way to do this to rename the field after the table is made? I
ask because it would be nice to not have to rename fields so often, for
routine operations.
Click to expand...
Click to expand...
 
Back
Top