thanks alot its working fine. I was seeing students with same first name, I included their last name, and report seem to be working fine.THANKS ALOT!!!
Thanks for the post; this query is working except its showing me multiple course records for each student, is it possible to see student most recent activity in the most recent course.Thanks again I really appreciate your help.
Object:I need to find students who have not performed an activity in last 3 days, I need to list their name, last event(activity they completed), date they submitted last activity, name of activity.
"ACCOUNTS is table name that carries student account information, like student name, username"...
Hi PHV thanks for the post, I tried to use your query but i m not getting any result? , ACCOUNTS.[USERNAME]=LSN_RESPONSES.[USER_ID]. Using rac2 query i m geting mulitple records. any suggestion
This query suppose to show student last event completed information with some other information, this information is stored in multiple tables, problem with this query is I am getting multiple results for each student instead of showing their most recent information. Last function doesnt support...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.