Search results

  1. O

    Replication Accessing Floppy

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

    Mode Function, Like in Excel

    That solved the problem precicely. Thanks alot.
  3. O

    Mode Function, Like in Excel

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

    Mode Function, Like in Excel

    Where do I search for this reference?
  5. O

    Mode Function, Like in Excel

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

    Cricket Database

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

    Cricket Database

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

    Cricket Database

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

    Cricket Database

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

    Cricket Database

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

    Cricket Database

    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.
Back
Top Bottom