I'm struggling with how to structure my (first) database. I have a table tblSCRATCHSCORES with records that contain the fields [MEETDATE] [PLAYERNAME] [SCRATCHSCORE1][SCRATCHSCORE2] etc. etc. I'm ultimately wanting a report that will show the results of a series of calculations after every meeting [MEETDATE] The calculations will be Total,Running Sum, Avarage & that sort of thing which will create handicaps, top three scratch players, top three handicap players etc. etc. Do I do the calculations in queries
& then base the Reports upon the queries? Can the queries do this stuff with no input from a user? In order
to do it without user input do I need to create a large amount of queries, one for each player with their name
as the criteria. Any words of wisdom that could steer me in the right direction would be wonderful & very
much appreciated
& then base the Reports upon the queries? Can the queries do this stuff with no input from a user? In order
to do it without user input do I need to create a large amount of queries, one for each player with their name
as the criteria. Any words of wisdom that could steer me in the right direction would be wonderful & very
much appreciated