var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a query which arranges the following businnes types;
SELECT QryCalcWPM.A.BusinessType & "/" & QryCalcWPM.B.BusinessType AS BusinessTypeCombined, QryCalcWPM.Score
ORDER BY QryCalcWPM.Score DESC;
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"
Therefore, KIOSK/MPESA > 1 then KIOSK was better in ranking than MPESA and if it was < 1 then it would have been the vice.
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):-
assume we have 50 businesstypes - the query should accomodate all that..
Any help please..