En curso

Algorithm for data transfer from Normalised Database to spreadsheet (CrossTab)

Hello, i will need a short algorithm for an output form.

Basically the output form will display some grades however i need the algorithm for data transfer from Normalised Database to spreadsheet (CrossTab)

Please check an image from the attached file and it should make it easier to understand what algorithm is needed to output that result.

Here is for my input form

When class selected a parameter is passed to the student can go to limit the source query to students in that class.

When Student and client have been selected.

1) Use a maketable query to make a temporary table for all the atomic marks required for that client (temprequired).

2) Use a make table query to identify the records that student already has for that unit in the mark table (temporally).

3) Use a (unmatch) type of query to identify the records in required that are not in already.

4) Use an append query to add these records (if any) to the marks table.

5) Pass parameters to the source output-form query to return the marks for this unit for this student and then refresh the form.

All of these steps will be done by using SQL that are going to be called using my VBA code. 

Should be pretty easy and quick and its need ASAP

£10 only as the algorithm only needs to be up to 10 lines

Habilidades: Algoritmos, Procesamiento de datos, Inglés (Reino Unido), Microsoft Access, Procesamiento en Word

Ver más: what is the algorithm, what is an algorithm, what is algorithm, what is a algorithm, what an algorithm, what algorithm, use of algorithm, use algorithm, the algorithm is, the algorithm, need for data processing, make algorithm, data algorithm, an algorithm is a, algorithm is, algorithm input, algorithm data, uk student, my grades, image algorithm, data transfer, atomic, algorithm and data, spreadsheet refresh vba, transfer data spreadsheet

Información del empleador:
( 18 comentarios ) Oxford, United Kingdom

ID de proyecto: #5916897

Adjudicado a:


Hey I can do this easily. Just ping me and I will give you answer in next 1-2 hrs Thnaks..............

£12 GBP en 1 día
(10 comentarios)

4 los freelancers están ofertando un promedio de £39 para este trabajo.


Hi Sir, I am ready to work for you.I have 9 years of experience in C/C++, python , java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work Más

£22 GBP en 1 día
(18 comentarios)

A proposal has not yet been provided

£105 GBP en 1 día
(4 comentarios)

Hi, i am Vinay. I am ready to work on this project. Please send more details on this. Thankyou!!!!!!

£18 GBP en 1 día
(0 comentarios)