Subquery implementing MODE computation.

J

JMSatMetro

I have a query...

SELECT tblOriginTAZ.fkFranchiseID, qryArcUniverseMin.TAZd,
tblFacilities.Facility
FROM (qryArcUniverseMin INNER JOIN tblOriginTAZ ON qryArcUniverseMin.TAZo =
tblOriginTAZ.TAZo) INNER JOIN tblFacilities ON qryArcUniverseMin.TAZd =
tblFacilities.TAZd
ORDER BY tblOriginTAZ.fkFranchiseID;

.....that I'd like to write a subquery on the TAZd field such that it
extracts the MODE TAZd for each fkFranchiseID.

Can someone please help?
 
Top