I'm trying to get back into SQL and stuck in a pretty easy statement.
My Database holds these Fields
PlayerName, PlayingHole, Hole1 ... to ... Hole18, Group
The Admin will enter a score for the group at its specific hole when it is given to him. At the moment
I'm listing the Hole ok - but when I add the WHERE statement to list which Group I get stuck...
'SELECT * FROM tblScoreCard Hole1 WHERE Group = 2 SORT'
I know this Statement is probably incorrect, however this one works but obviously no sorting of
'SELECT * FROM tblScoreCard Hole1'
This gives me all data from the field Hole1 in the Table. Which is fine, but I only want it from the