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]

Re: renaming field names in a query table

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 <mrousseau55@ho tmail.com> wrote in message news:<419d2166$ 0$14492$c397aba @news.newsgroup s.ws>...[color=blue]
> 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![/color]