Make Table Query and Expression Names

[paborden]

Hi all,

I have a Make-Table Query that has five expressions. I have changed the properties of these columns so that, when you view the query, it shows the column names I have chosen. So, instead of Expr1, I get "Haggis", and instead of Expr2, I get "Cold Toast".

BUT, when this query creates a table, the column headings revert to Expr1 and Expr2. Is there any way to make my custom column headings stick in the new table?

I should add that I frequenty run this query and overwrite the table. Thus, even if I go into the table and change the field headings, as soon as it is overwritten these changes revert.

 

[EMP]

Please post the SQL statement of your query, that is the statement in query SQL View.

^

 

[pbaldy]

Also, you might consider emptying and filling the table, rather than creating it each time. I think it's more efficient.