Hi! I'm stuck with this query I hope someone can help me: I have this table for Patients executing tasks:
IdPatient  Date IdTask Points
 
where IdTask is the name of each task, there are 4 different tasks: Task1, Task2, Task3, Task4, Date is the date the idPatient executed the idTask and Points is a number showing the punctuation he took in the task 
 
My result table should look like this:
 
IdPatient Date Task1 Task2 Task3 Task4
 
For each idTask showing the Points each idPatient took each Date.
 
Each idPatient can execute the same idTask more than once in one Date or in different Dates.  Not all idPatients execute every task so there will be some null values.
 
Thanks
 
 
 
 

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.yahoo.es

[Non-text portions of this message have been removed]