Code:
SELECT qryRankings1.RankingID, qryRankings1.ProjectID, [LocalMatchPoints]+[CriticalOppPoints]+[ProjectReadinessPoints]+[SafetyPoints]+[CongestionPoints]+[CostEffectivenessPoints] AS TotalPoints, T.MinCostE, IIf([MinCostE]>0 And [costEffectiveness]<>0,IIf(([MinCostE]/[CostEffectiveness])*15>15,15,([MinCostE]/[CostEffectiveness])*15),0) AS CostEffectivenessPoints, qryRankings1.RequestedAmt, qryRankings1.WeightedCrashes, qryRankings1.MaxWeightCrash, qryRankings1.SafetyPoints, qryRankings1.VCRatio, qryRankings1.MaxVCRatio, qryRankings1.CongestionPoints, qryRankings1.Subpoints, qryRankings1.CostEffectiveness, IIf([LocalMatch]="25%",5,IIf([LocalMatch]="30%",10,IIf([LocalMatch]="35%",15,IIf([LocalMatch]="40%",20,IIf([LocalMatch]="45%",20,IIf([LocalMatch]="50% or >",25,0)))))) AS LocalMatchPoints, IIf([CriticalOpp]="Yes",5,0) AS CriticalOppPoints, IIf([ProjectReadiness]="Design",5,IIf([ProjectReadiness]="ROW",10,IIf([ProjectReadiness]="Bid Phase",15,0))) AS ProjectReadinessPoints
FROM qryRankings1, (SELECT Min([CostEffectiveness]) AS MinCostE FROM [qryRankings1] WHERE [CostEffectiveness]>0) AS T
Up to you to check whether the results are as expected