Query - Can't sort on calculated field?

  • Thread starter Thread starter diarmuidq
  • Start date Start date
D

diarmuidq

SELECT DCIResults.Name, DCIResults.ConsWin AS Win, DCIResults.ConsLoss AS
Loss, DCIResults.ConsDraw AS Draw, [Win]-[Loss] AS Diff
FROM DCIResults ORDER BY [Win]-[Loss];

I'm prompted to enter Win and Loss. What should I change?
Thanks
Diarmuid
 
Try:
SELECT DCIResults.Name, DCIResults.ConsWin AS Win, DCIResults.ConsLoss AS
Loss, DCIResults.ConsDraw AS Draw, [Win]-[Loss] AS Diff
FROM DCIResults ORDER BY [ConsWin]-[ConsLoss];

_____________
Duane Hookom
MS Access MVP
 
SELECT DCIResults.Name,
DCIResults.ConsWin AS Win,
DCIResults.ConsLoss AS Loss,
DCIResults.ConsDraw AS Draw,
[Win]-[Loss] AS Diff
FROM DCIResults ORDER BY [Win]-[Loss];

I'm prompted to enter Win and Loss. What should I change?
Click to expand...

ORDER BY ConsWin - ConsLoss

or

ORDER BY 5

(using the column position). You also need to change the definition for the
fifth column to

SELECT ... AS Draw, ConsWin = ConsLoss AS Diff

HTH


Tim F
 
Back
Top