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

    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?

    Thanks
    Tom
    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
  •