Search results

Hi Arnelgp, yes I think that's it, I wasn't sure at first but now I see every runner once and the event when they achieved their fastest time. That's fabulous thank you so much. Homage to ebs17 and MajP also, I think it was my poorly worded question that caused any confusion but thanks to you...

Sorry to cause you pain ebs17, you may like to try some Keats if my poetry is not to your taste. Thank you very much for your help, I have made some progress now once I'd typed in the SQL you supplied me exactly as you'd supplied it and without my typos and errors. MajP Thanks also, I have...

Well you make some good points, even if I do feel like I'm getting beaten up. I'm glad you like my rhyming, I'm probably a better artist than scientist as you may tell. How I come up with such thoughts is a long and complicated story which I am describing in my current novel. I'll be sure to...

TotalSeconds is a calculated field SELECT T.* FROM tblResults AS T INNER JOIN ( SELECT RunnerRef, EventRef, MIN([h]*3600+[m]*60+=DMin("[h]*3600+[m]*60+) AS MinTime FROM tblResults GROUP BY RunnerRef,EventRef)...

Ebs17, sorry to be stupid but what does T represent in your example please?

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...

Thanks again, All the points you mention are very relevant to my situation, I guess Access is so massive (probably true of a lot of software) that there's so much to explore in the depth of it. The examples you provide MajP are incredibly useful, I can put those into practice from now on. I...

I'm so sorry, I'm beginning to think I'm not cut out for this. Thank you MajP

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...

Thank you so much June7, you've fixed it. I'd only referenced the main form and forgotten to reference the subform It was forms!frmRunnersAndClubs!txtRunner It should be forms!frmRunnersAndClubs!frmRunnersAndClubsSubform!txtRunner All works fine now and thanks for the heads up on the better...

Thanks June7, let me try that and txtBanner isn't bound I just use it empty as a title depending on amend or add records

Sorry jdraw yes, I hurridely pasted and copied, from the access sql view

Chortle, the trouble is George you just keep enabling us (I can only speak for myself of course) by being so helpful!:)

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...

All sorted now, Thank you for the help.

Thanks Pat, I wanted to use the natural key in table events as the primary key but guess that's not possible so I use Autonumber as Primary key as you say and works fine. I created a unique index as you suggest on the natural key name and date. I'not sure if I have understood completely...

Pat, I have tried your index suggestion and rearranged the relationships as your advice, I think this is more satisfactory but I can still add the same runner again at the same event probably because I have misunderstood or haven't applied the changes correctly. Please have a quick gander at the...

Hi All, Thanks for all this, I need to go away and assimilate this info and put these suggestions into practice. Sorry I didn't reply, I am having a spot of trouble when logging in, I get the message something went wrong then reset my password and still doesn't work. Then magically this...

Thanks Ranman, is that like a many to many join table between events and runners ?

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...