Make Table Question

[PeterL]

I have a make table query which by default uses the field names from the query source as it's field names. Is there a way to define my own field names in a make table query?

Thanks

 

[BNPMike]

A query is like a view in normal relational parlance. One of the many roles of accessing base tables via views is you can change field names to something more user friendly. In Access you can create a new field like FriendlyName:[WierdInternalName]. In SQL you can say WierdInternalName AS FriendlyName. Either way your new table will have your chosen names.

 

[PeterL]

I'm sorry but I'm still confussed. My query has a current field which will be used in the new table. How do I change the name in the query prior to making the table.

 

[BNPMike]

I gave you two methods.

First one uses the QBE grid. Instead of selecting the field, you type a new entry FriendlyName:[WierdInternalName].

Second one uses SQL. Go into the query's SQL view and type
AS FriendlyName after the WierdInternalName reference in the SQL.