Search results

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

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

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

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

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

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

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

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