referring to alias names in subquery from outer query

[Earth]

Hi everyone,

I have a query that has a subquery. The subquery is only returning two columns: one is a calculated column, and the other is the original column. I have given the calculated column an Alias.

Quick question: Can I refer to this calculated column by alias name in the outer query? Access (2000) doesn't seem to like it.

Thanks in advance.

 

[dalchri]

Refering to the Alias name in the outer query should be fine. If you join the subquery to another table or subquery, make certain that the alias name is not duplicated with the name of another field in the other table. Try placing brackets around the alias name in the subquery and the name of the field in the outer query. You may have inadvertently used a reserved word as your alias (for example [Number] or [Count]).

What sort of error message are you getting?

 

[Earth]

Hi Dalchri,

I figured it out. Yes, I could refer to an inner query alias in the outer query. (I tested this by giving the original column and alias, and I could refer to it in the outer query). My problem came from some where else (trying to sum date values actually!).

Thanks for your help.