Recent content by Wilkesy93

  1. W

    Excel or Access

    Just downloaded it, it's incredibly impressive!
  2. W

    Excel or Access

    Yeah if that's ok?
  3. W

    Excel or Access

    Yes that would suit my requirements. I've been working on this the last few days based on all of your advice and I'm now at the point where I've replicated all the functionality of my spreadsheet but in Access and it's a lot better than the spreadsheet ever was, so thank you all for your help
  4. W

    Excel or Access

    Thanks for this very helpful, so if I want to collect data on each player for the tournament as a whole but multiple stats would I just add fields on to the TournamentPlayers table for each stat I wanted to collect? Feel like I'm getting somewhere!
  5. W

    Excel or Access

    Hi Everyone, Thanks for all the advice super useful. I've done some reading overnight and think I have the beginnings of what I want, I've posted it below, if you could let me know if i'm along the right lines that would be super useful Table 1 (Player) Player Id, Player Name Table 2...
  6. W

    Excel or Access

    Never code in excel, just sort of force formulas to do what I want them to, which probably explains some of the slow speed as they're probably not written very well. Happy to learn, still reading through the Wikipedia post from above
  7. W

    Excel or Access

    They're various statistics that I track. Strokes Gained: Off the Tee Strokes Gained: Approach Strokes Gained: Ball Striking (OTT + APP) Strokes Gained: Around The Green Strokes Gained: Tee to Green (BS + ATG) Strokes Gained: Putting Strokes Gained: Total (T2G + Putt)
  8. W

    Excel or Access

    Attached
  9. W

    Excel or Access

    Hi Everyone, I currently store golf statistics on a week by week basis on a golfer by golfer basis in Excel. I store things such as Player Name, what the tournament was, course name, then lots of info about the course and then finally the statistics of the golfer for that week. I'm adding...
Top Bottom