Search results

  1. G

    Solved Minimum Values From A Set of Records For Each Occurrence Then Create Those Results in Another Table

    I would like to determine the minimum time as personal best for each runner from a number of events. I would then like to pick out this value to provide a subset of data only displaying the runners and their fastest time. Is it better to use a query or vba? I’m struggling with both. If I use...
  2. G

    Solved Average Speed, Decimal Places and Frustration

    Hello, I fear I have been dabbling again and am stuck despite good progress made in my application for my running club thanks to the help from this forum. I am getting frustrated now as I frequently meet this decimal place problem. I have been able to overcome this previously by simply...
  3. G

    Solved Specific Record from Continuous Forms To Pop up Single Form To Amend That Specific Record

    I have noticed some posts very similar to my question, apologies if I am duplicating but I couldn't see quite the same issue I am having. I have a subform in continuous forms view with a list of runners each with an autonumber PK RunnerRef The text box control (txtRunner) with this pk as the...
  4. G

    Relationships Headache

    Hello, I've built some satisfactory forms for data entry but I can't determine the right way to go about the relationships. As I entered runners into an event using a subform based on runners and results and a main form based on events, I found I could duplicate runners per event which renders...
  5. G

    Hello From A Dabbler

    Hello, I am Chris and have been using Access for many years but have never got particularly proficient with it. I hope to learn from those who can use Access properly and am always impressed with the patience and generosity of such people who are willing to pass on their knowledge...
Back
Top Bottom