Hi All, (first post)
I receive the following error: "Syntax error in query expression (SELECT (Scores) FROM (String Results) WHERE (Stage) = 1. Help?
I'm new to Access and trying to create a SELECT Sub-query. I have a Table that has scores for competitors who completed different stages of the competition. The table has all the scores for all the stages, but I want to create a field/column to select just one particular stage score. I want the query to look something like this:
[Competitor ID] [Stage1Score] [Stage2Score] [Stage3Score]
I have tried to create a SELECT sub-query in the Field with the following syntax
Stage1Score: (SELECT [String Results].[Score]
WHERE [String Results].[Stage] = 1)
I get the syntax error shown above and am stuck. Any help is appreciated.