Access database tidy up (uses RANK function)

This project is to tidy up a access database (attached) and get the queries working correctly with tables. The RANK function is a central focus. There are numerous instances where times need to be ranked to give placings. Where a time is equal to another, both should get the same placing (eg tie for first would give placings of 1, 1, 3)

I came unstuck with nested tables in the query so the following workaround was used:

• xTotalTime taken from xxTotalTimeQuery

• zReportTable: Stage Results Men/Women comes from zzStageResults Men/Women

• zReportTable Top20 from zzTop20Report

• zReportTable: Total Time from zzTotalTime Query

• xHandicap from xxHandicapReults

• zReportTable: Handicap from xHandicap Query

At the conclusion of this project, it should not be necessary to copy tables like this; the reports should work straight away!

There are two pieces of follow on work which will be awarded at the satisfactory conclusion of the project:

1) Add additional queries (small piece):

a. Calculate the two different age classes from YOB

b. A query to show competitors who have no results

2) Integrate the database with a spreadsheet that uses an ActiveX control to import the data, process and dump out the tables PUNCHES and TIMINGPUNCHES. This uses VBA and prints a summary for each competitor. This project will take all the functions of the spreadsheet and put them into the database so only one platform is needed (Access, rather than Excel + Access)

Habilidades: Microsoft Access, Visual Basic para Apps

Veja mais: tidy access query, access rank function, visual age, up work competitors, microsoft project import, i need an access database, uses for excel, microsoft vba, microsoft excel VBA, excel uses, excel 2013 vba, vba access excel, microsoft access vba, in process access, c# with access database, c with access database, access database, project database vba excel, excel database visual basic, vba excel copy, 2013 visual basic applications excel, project 2013 access, visual basic database excel database, excel 2013 microsoft visual basic, access query excel

Acerca do Empregador:
( 6 comentários ) Auckland, New Zealand

ID do Projeto: #5105851

Concedido a:


Hi.. I have gone through your requirement of tidying up database attached and have some queries which can be clarified on personal messages. In attached databases, i can see tables/queries but exactly where you are Mais

$133 NZD em 2 dias
(14 Comentários)

9 freelancers estão ofertando em média $138 para esse trabalho


Hello I am expert in MS ACCESS and VBA. I can help with good quality. At your disposal for more informations. Regards

$200 NZD in 5 dias
(4 Comentários)

Hi I have more than 10 years experience in database [login to view URL] I have worked using rank function. please see my profile. Example: MOVIE DISTRIBUTOR HAVE THE BETTER PROFIT BY MONTHS SELECT MONTHS Mais

$155 NZD in 3 dias
(1 Comentário)

Hi, I am interested in this project. I am an experienced professional and have lots of development experience with me. If interested in hiring me then please let me know so that we can discuss and finalize the require Mais

$88 NZD in 3 dias
(3 Comentários)

I want this to work, I really want this. I am responsible and can finish this work in a very short time. Please hire me.

$155 NZD in 3 dias
(0 Comentários)

Experienced in MS Access/VBA/Excel (12 years). Being newbie on ready to complete project with minimal price to earn experience/reputation points.

$56 NZD in 3 dias
(0 Comentários)

Hi, I have been developping MSAccess application for more than 10 years, including vba fonction and mooving MSExcel Apllication ton MSAccess. I have read your project carrefully and open the access file you provide, I Mais

$100 NZD in 6 dias
(0 Comentários)

Hi there - I downloaded the file you provided and checked it to make sure that I will be able to assist you with your project. I've been working with MS Access for over 20 years now and have created many systems Mais

$200 NZD in 4 dias
(0 Comentários)

hello, i had highly experience 10 years in vb6 + vba macros in all MS. office soft (2002 - 2013), OpenOffice Calc 3.5 and 4.0 will do excellent job for you!

$101 NZD in 3 dias
(0 Comentários)

A proposal has not yet been provided

$250 NZD in 10 dias
(0 Comentários)