experten hier alom aanwezig, graag jullie hulp met uit te vissen wat er mis is met dit stukje code:
Ik krijg namelijk steeds een syntaxis-fout en mijns inziens zou dit toch ongeveer moeten kloppen?
Ik krijg namelijk steeds een syntaxis-fout en mijns inziens zou dit toch ongeveer moeten kloppen?
Code:
SELECT [SCORES Query].Name,
[SCORES Query].Nmb,
[SCORES Query].Date,
[SCORES Query]![Player 1 Score] AS [Player 1 WIN],
CASE [SCORES Query]![Player 1 Score] AS [Player 1 WIN],
WHEN [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 2 Score]
AND [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 3 Score]
AND [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 4 Score]
AND [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 5 Score]
AND [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 6 Score]
AND [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 7 Score]
AND [SCORES Query]![Player 1 Score]>[SCORES Query]![Player 8 Score]
then 1
else 0,
end
[SCORES Query]![Player 2 Score] AS [Player 2 WIN],
CASE [SCORES Query]![Player 2 Score] AS [Player 2 WIN],
WHEN [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 1 Score]
AND [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 3 Score]
AND [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 4 Score]
AND [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 5 Score]
AND [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 6 Score]
AND [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 7 Score]
AND [SCORES Query]![Player 2 Score]>[SCORES Query]![Player 8 Score]
then1
else 0,
end
FROM [SCORES Query]
ORDER BY [SCORES Query].Name;