Im trying to display a chart of the users who have passed the
most modules first timemodules that my users have passed first
I cannot add/chnage the database but if passible i could add
a different database.
This is my query for the passes and fails i have.
from pps_scos, pps_transcripts, pps_principals
where pps_scos.sco_id = pps_transcripts.sco_id
and pps_transcripts.principal_id =
and pps_scos.name like 'MT%'
and pps_principals.name like 'Lee Duncan'
AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'I'
AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'X'
AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'R'
AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'N'
AND PPS_TRANSCRIPTS.TICKET not like 'l-%'
the relevent iformation that it returns here is -
MTM-072 Hand Injuries F Lee Duncan
MTM-072 Hand Injuries P Lee Duncan
MTM-099 Sexually Transmitted Diseases F Lee Duncan
MTM-099 Sexually Transmitted Diseases P Lee Duncan
MTM-066 Testing VITAL Connectivity P Lee Duncan
MTM-073 Understanding Email P Lee Duncan
MTM-055 It's Your Choice P Lee Duncan
I then want to store the amount that i have passed first
time, in this case 3 and then turn it into pic chart. But i need to
do this with all users, any suggestions on how this could be done?