Hi,

I have a query which arranges the following businnes types;

Code:
SELECT QryCalcWPM.A.BusinessType & "/" & QryCalcWPM.B.BusinessType AS BusinessTypeCombined, QryCalcWPM.Score
FROM QryCalcWPM
ORDER BY QryCalcWPM.Score DESC;
Results:

BusinessCombined Score
KIOSK/MPESA1.03
MPESA/TAXI0.98
KIOSK/TAXI1.02
MPESA/TUKTUK1.19
TAXI/TUKTUK1.21
KIOSK/TUKTUK1.23

By the above result:

KIOSK/MPESA 1.03 means "KIOSK is better in ranking than MPESA",
MPESA/TAXI 0.98 means "MPESA is not better-off in ranking than TAXI"
etc


Therefore, KIOSK/MPESA > 1 then KIOSK was better in ranking than MPESA and if it was < 1 then it would have been the vice.

so now;

I want to write a query to rank the 4 business types with the above logic; So the results will be;

If we use this inferential for all, we conclude (it should display the results as):-

KIOSK
TAXI
MPESA
TUKTUK


assume we have 50 businesstypes - the query should accomodate all that..

Any help please..

Thanks