Recent content by Oswald_Cobblepot

I have replicated my database and now every time I move between forms or perform any action it checks the floppy for no apparent reason. Does this happen for any particular reason? Thanks

That solved the problem precicely. Thanks alot.

Sorry I wasn't searching in the right place. But, do you know if there is a way to get it to display the mode for not the entire table but for different (in my case) playerId's as in the totals box. Thanks

Where do I search for this reference?

Is there any way in Access to retrieve the mode (most frequent value) in a set of data. Excel has this function but I don't know if Access does. Thanks

Thanks a lot, that has solved the problem perfectly. You really saved me a lot of hair pulling and keyboard smashing. Thanks again Colin

When I try to join the two it comes up with the relationships that i have previously set up in the start. If the player has two separate matches with the same number of wickets, it shows them both. I don't know how to just select the first one. Thanks Colin

Thanks a lot for that it works fine. Now i need it to pick up the Match ID from the match that it just found. I need it so it can find the date and opposition from a separate table. What can I do to retrieve it? I'm probably being a pain in the arse but thanks anyway.

Thanks for the reply. The problem is though, that query picks the most wickets ok but when it comes to the runs it picks the lowest one in the entire field not the one that corresponds to the number of wickets found by max(wickets). The only way i have found so far is the one i mentioned...

I've tried using that but what i need is to have the stats for each separate bowler, not just the whole lot. I can get it to display what i want for 1 player by sorting wickets descending and runs ascending and then taking the top record. This only works though when i specify a player ID to look...

I have created a database for tracking the results of my U/9 team but i am having trouble getting it to retrieve best bowling (max wickets, min runs) for each player.