ctwo
Merely Rhetorical
I've forgotten some basics of using Access, so wondering if anyone here has some familiarity setting up a form for logging times?
For example, I have a spreadsheet that lists motorcycles in the first column, and then each following column head lists a track. Each cell then contains a (best) lap time, for example. The far right column and bottom row each has a sum total of the row or column data.
What I did was create a table of motorcycles, then a table of tracks.
Now I need to insert the magic that makes the form work to tally up the numbers. I'm mostly looking for some higher level strategy on how to approach this, but at the moment I cannot quite figure out what relationship (between tables) should be defined and then if I should make a query or just build the form data from the fields I have. It seems I don't have any place to store all the data, however, so I wonder if I need to make a comprehensive table like in Excel.
For example, I have a spreadsheet that lists motorcycles in the first column, and then each following column head lists a track. Each cell then contains a (best) lap time, for example. The far right column and bottom row each has a sum total of the row or column data.
What I did was create a table of motorcycles, then a table of tracks.
Now I need to insert the magic that makes the form work to tally up the numbers. I'm mostly looking for some higher level strategy on how to approach this, but at the moment I cannot quite figure out what relationship (between tables) should be defined and then if I should make a query or just build the form data from the fields I have. It seems I don't have any place to store all the data, however, so I wonder if I need to make a comprehensive table like in Excel.