Refering to a query field within the same query

[rojo527]

In Access you can refer to a query field within the same query. For example, the following query produces two fields (fullName and fullNameLength) where the second field is derived from the first.

SELECT


firstName & " " & MI & " " lastName AS fullName,
Len([fullName]) AS fullNameLength
FROM tblCustomer;

This query works fine within Access but when I run the query remotely via PHP, I get a query error and it dies. The culprit seems to be the reference in the second field referring to the first field. Has anyone encountered this problem? Is there another way of referring to fields within the same query? Note, the above query is just an example. It would be easy to rewrite it to avoid the reference but I use this feature in a lot of other places and would like to know if there is something I am doing wrong.

Thank you

[RuralGuy]

It has always been my experience that you cannot refer to an alias in a query. In this case I would have:
Len(firstName & " " & MI & " " lastName) AS fullNameLength