Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004

    Unanswered: Un-able to delete record from query

    Iím un-able to delete records from my query

    Thatís how the select statements look

    SELECT [Group Creation].GroupCreated, Students.StudentRecordID, Students.GroupID, Students.StudentID, Students.DateJoiend, Students.FirstName, Students.LastName, Students.ParentsNames, Students.Address, Students.City, Students.StateOrProvince, Students.PostalCode, Students.PhoneNumber, Students.EmailName, Students.Major, Students.StudentNumber, Students.Notes
    FROM Students INNER JOIN [Group Creation] ON Students.GroupID = [Group Creation].GroupID
    ORDER BY [Group Creation].GroupCreated, Students.GroupID, Students.StudentID;

    Iím using this query just for sorting purpose,

    Can anyone please look at the attached sample DB and see if they have any solution?

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts