AS question

[Guest]

This is my second post in 10 minutes - hope that's OK!

My query has several similar calculated fields called PRank, QRank, RRank,
....etc. Here is part of PRank.

PRank: (SELECT Count(*)
FROM (SELECT DISTINCT qrySales.PSales
FROM qrySales) AS DIS
WHERE DIS...etc

up until now I have been using aliases PDIS, QDIS, RDIS.... I tried using
just the same alias DIS for all of them, and everything seemde to work OK.
Question - Is this safe to use the same alias repeatedly like this?

thanks

 

[John Spencer]

In this case where you are using this subquery in the SELECT clause, it
should not cause any problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================