Need Advice - Using SA/DA for running club site
I have a couple of questions, anyone who's able to offer suggestions/advice, I really appreciate it.
Function - I want to allow the runners to "sign in" so that I can track attendance. Prizes are given after 10, 50, 100 runs etc, so I need to be able to run a report that shows a "total number of runs attended".
My approach? - I thought I could create a page where the members can enter their email address and password and submit. On submit, I want to Post (i think) to my table, user_ID (user id and email address in another table), the date (dd/mm/yy), and a default integer of "1" in run_Total column.
Then, on my report, I thought I could use a calculation like SUM(run_Total)
I'm not a coder, so am familiar with support tickets, but was hoping to at least get on the right path first.