¡Hello!
My problem is that I'm writting queries in access, and when I try to write an Alias for a field it says "ODBC call failed", however I can run the query without the alias;
that alias, once defined on the select clause, it is used on the where clause.
I have found that writting (theAlias:" " & thefield), I mean, with a space before the field I want to rename, it works, but I have a lot of queries done and I wouldn't like to change all of them.
First: does anyone know why it works with the space?
Second: how could I solve it without the space?
Thank you
My problem is that I'm writting queries in access, and when I try to write an Alias for a field it says "ODBC call failed", however I can run the query without the alias;
that alias, once defined on the select clause, it is used on the where clause.
I have found that writting (theAlias:" " & thefield), I mean, with a space before the field I want to rename, it works, but I have a lot of queries done and I wouldn't like to change all of them.
First: does anyone know why it works with the space?
Second: how could I solve it without the space?
Thank you
