how to change the name of field in a query

grad2009

Registered User.
Local time
Today, 08:11
Joined
Feb 7, 2010
Messages
30
hello all,

I used (AS) to change the name of a field in a qurey but it did not changed. However, for the calculated field when i use (AS) it is ok.
Is there any way to change the name of the field in a qurey.

Thank you very much.
 
It should work. I just tested

FieldName AS Test

And Test is what was displayed in the query. Can you post a sample or something?
 
how about as you contruct the query in design mode

The simple way is:

testabc: [test] * 1

This is generating a new fieldname testabc by using an existing field from a variable [test] which would have come from a table or another query
 

Users who are viewing this thread

Back
Top Bottom