Search results

  1. K

    Using Top Values in a query

    Ok - So I've cut down my database to a manageable level and tried option one again. This has resulted in showing just the 10 highest scores overall whereas what I was trying to get was per player I think I must be doing something wrong
  2. K

    Using Top Values in a query

    Many thanks for that I've tried Option 1, but when I try to run the query, it just hangs forever and crashes. which is quite annoying really
  3. K

    Using Top Values in a query

    Hi guys and girls, I am an absolute beginner with Access so please be gentle with me lol I have a database with Players Names, Tournament Names and Points Scored. Each player enters different tournaments and scores different points depending on how far they progress through the tournament...
  4. K

    How to set up a grid in a table

    Yes thanks for that. I have decided to go for a simple version of my original idea. It makes it much easier for me. So my final question is- I have a query set up which shows athletes and total points they have throughout the season. I can get it to display in descending order so that the...
  5. K

    How to set up a grid in a table

    I think my final hurdle is as follows: In excel you can have a cell where you put a formula in based on other cells and it populates the answer. I don't know if you can do the same sort of thing in Access though? Basically I reckon I need to create a query or a report (who knows??) which will...
  6. K

    How to set up a grid in a table

    I have attached my test database and also a typical Excel spreadsheet which is what I would be using to import the data into the 'Results' table. I just don't know how to get the database to recognise that eg- London is a grade A race therefore when I put in the 'results' table that somebody...
  7. K

    How to set up a grid in a table

    Thanks for that Gemma, So when you say 'do a look-up', is that a process on Access or do you mean manually look up on the table. The effect I am trying to achieve is to be able to enter the placement a certain athlete finished, and for the system to automatically assign the correct number of...
  8. K

    How to set up a grid in a table

    Hello everyone, I am organising various athletics meetings. Different races are graded differently by their importance. I have a table 'Athletes' and a table 'Meetings' which shows which grade each race is. Am I able to create a table which would be able to recognise how many points are...
Back
Top Bottom