Em Andamento

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

Ver mais: tidy access query, access rank function, visual age, microsoft project import, uses excel, microsoft vba, microsoft excel vba, excel uses, excel 2013 vba, vba access excel, microsoft access vba, process access, access database, project database vba excel, excel database visual basic, vba excel copy, project 2013 access, access query excel, vba function, excel tidy data, excel access import data, access control database, excel summary results, access summary, excel import access

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

ID do Projeto: #5105851

Premiar a:

mail2vimalarora

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 Avaliações)
4.0

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

ziafar

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)
3.5
Reza2012

Hi I have more than 10 years experience in database administration.Previously 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)
1.7
jawadaman

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)
1.7
romeliasaineh

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)
0.0
gleberofeev

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

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

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)
0.0
Steponitgal

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)
0.0
logoDS761

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)
0.0
Pharoa

A proposal has not yet been provided

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