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?
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?