Search results

  1. S

    Generating ID using letters from related tables and sequential numbers

    Hi Guys. I am preparing a database that stores the records of runners such as their results, the runs they take part in, the locations where the runs take part, etc. One of the requirements is to have a the RunID as the first 3 letters of the LocationName, and then a sequential number which is...
  2. S

    Counting number of runs for each runner using update query

    Hi guys. Im pretty new to using access and am creating a database to store records of the runners and the runs they take part in. I have five tables, three of which are important for this question i have: Runner -RunnerID (Primary Key) -RunnerName -NoOfRuns -DOB -BestTime Runs -RunID (primary...
Back
Top Bottom