Write VB Code to Update Access Database Table

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.

Evner: Microsoft Access, Visual Basic

Se mere: how to update table in vb net, code for search button in vb net with ms access, how to insert data in ms access using vb.net 2008, add delete update in vb.net using ms access, visual basic database, how to connect microsoft access database to visual basic, insert delete update and select data in ms-access with vb 2010, update query in vb.net with ms access, code project access database, vb6 update access database, update access database website script, update access database using asp, create access database table using, access database create table, csv access database vba code, simple vbscript update access database, javascript update access database, update access database using script, update access database code, code store text form vb project ms access database

Om arbejdsgiveren:
( 13 bedømmelser ) Ashton-under-Lyne, United Kingdom

Projekt ID: #20748222

Tildelt til:


Hello, sir! I am happy to put my bid on your project. I have a full of experience in accdb processing using VBA. I have finished many projects like this. I can show you one of my projects. I promise I will do your proj Flere

£50 GBP in 2 dage
(5 bedømmelser)

12 freelancere byder i gennemsnit £139 på dette job


Hello! I am Branislav from Serbia, Microsoft Access MVP for 2008 and 2009 (Most Valuable Professional title), professional Access, SQL and Office programmer for past 25 years, contributing editor of printed PC magazin Flere

£135 GBP in 7 dage
(232 bedømmelser)

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Flere

£135 GBP in 2 dage
(11 bedømmelser)

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

£70 GBP in 7 dage
(6 bedømmelser)

hello sir ! how are you ??? please talk to start this work. i can do it as per your instrections, regards

£50 GBP in 2 dage
(10 bedømmelser)

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.

£150 GBP in 3 dage
(2 bedømmelser)

Hi, there! I am an professional programmer, I have read your post and excel file carefully and I am very interested in it. I have rich experience in Software development. So, I'm sure I can satisfy your request with hi Flere

£150 GBP in 7 dage
(2 bedømmelser)

⭐ Dear, Client ⭐ Nice to have you. I have read your description carefully and I understand the goal. I have rich experience in Microsoft Access and VBA macro. I can help you surely and finish your job in time. I can st Flere

£180 GBP in 3 dage
(1 bedømmelse)

hello ! I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Awaiting an affirmative response from Flere

£135 GBP in 3 dage
(0 bedømmelser)

Hi there, I have completed 40+ Windows Applications with my clients. Customer satisfaction is my forecast duty. The efficient code in a timely manner is guaranteed as I believe in strong customer-client relationship Flere

£250 GBP in 7 dage
(0 bedømmelser)

Hello Chief, I have read the project specifications furnished by you. I will assist you in the development of the website platform. Here a bit about myself. I'm a full-stack developer experience of 10+ years. I wor Flere

£222 GBP in 30 dage
(0 bedømmelser)

Good day! I'm a licensed full stack programming developer and designer. I have many experiences in python/Django and python selenium webscraping and python image processing by using python openCV package. I have many Flere

£135 GBP in 7 dage
(0 bedømmelser)