Rename a field of a Query

[mp3909]

I have this query:



When I click off the design view and see it as table, the 2nd column is called "Expr1".
It is possible to rename it to something more meaningful?

[CJ_London]

yes - just replace with whatever name you require - avoid using spaces and non alpha numeric characters, reserved words or same name as existing fields in source

[mp3909]

Do you mean I can delete the word “Expr1” in the snapshot I had posted and write what I want as the name of the column? I tried doing that and it gave an error

[davegri]

I tried doing that and it gave an error

Be sure to include the colon. If the replacement contains a space put it in square brackets.

[mp3909]

cool, its working now.
thanks!