Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by s121701

  1. s121701

    How to use MAX function with multiple records

    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!!!
  2. s121701

    How to use MAX function with multiple records

    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.
  3. s121701

    How to use MAX function with multiple records

    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"...
  4. s121701

    How to use MAX function with multiple records

    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
  5. s121701

    How to use MAX function with multiple records

    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...
See more

Part and Inventory Search

Back
Top