Hi,
I am working with Access 2003 and have the following problem when I try to order by - WSM Score.
1) Message box - Enter Parameter value when I click Ok
2) It is not arranged in WSM Score
e.g
WSM Score
23
26
21
The order is still retained any help please
Code:
SELECT TblBusTyp.BusinnesType, [%Cri1]*[Weight1] AS [Calc %Cri1], [%Cri2]*[Weight2] AS [Calc %Cri2], [%Cri3]*[Weight3] AS [Calc %Cri3], [%Cri4]*[Weight4] AS [Calc %Cri4], [Calc %Cri1]+[Calc %Cri2]+[Calc %Cri3]+[Calc %Cri4] AS [WSM Score]
FROM TblBusTyp, QryALLQs
ORDER BY [WSM Score] DESC;
Thank you