renaming field names in a query table

[Michel Rousseau]

I have created a table through a query. How can I create a new query
which will create the exact same table but rename some of the field
names? Thanks.

Michel Rousseau
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Carlos Nunes-Ueno]

Just like you'd rename a field in a regular select query. If you're
using Access's query design tool, then enter the name like this:
NewName: OldName. If you're doing it in SQL, the it's like:

SELECT OldName AS [NewName] INTO NewTable
FROM OldTable

Hope that helps,

Carlos
Michel Rousseau <mr*********@hotmail.com> wrote in message news:<41**********************@news.newsgroups.ws> ...

I have created a table through a query. How can I create a new query
which will create the exact same table but rename some of the field
names? Thanks.

Michel Rousseau
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!