I have an Access Database with a table containing data for events that I need ranking for each event based on a score.
Each event has a unique ID and each item has an unique ID and a score, I need each item in the event to have a rank based on the score. (lowest score rank 1 etc.)
Where items have the same score in the event they need to be given a different rank rather than the same rank. See the example spreadsheet.
I need some code within the access database that I can run to update the rank column in the database. I only need it to update records without a rank. Once data is loaded it will not be modified but new events will be added.
See attachment for an example of the structure, my actual data is slightly different but the principal is the same.
Once the project starts I will send the database I have.
I have attached a sample spreadsheet to give a rough idea of the data.
12 freelancere byder i gennemsnit £139 på dette job
Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have read your description could you message me for details
I can help you with this project. I'm expert developing applications based in Access and VBA. Please do not hesitate to contact me so we can furher discuss the details of the project.