scottieJ
Badges: 3
Rep:
?
#1
Report Thread starter 1 month ago
#1
HI Is there a way when you have created your list to filter it alphabetically but so the ID number says where it is so then you get A next to one as when I filter the names the numbers are moving with the list
0
reply
DraconisAudiat
Badges: 12
Rep:
?
#2
Report 4 weeks ago
#2
I don't understand what you're asking for but I'm going to guess wildly.

If you have a table of results that is people, courses and results like:
Name, Subject, Grade.
David, History, C
Adam, Chemistry, A
Bob, English, B
Bob, History, A
Chris, French, B
Adam, French, C
David, Chemistry, A

And you want to sort it so the top mark per person is listed first then you want to sort by Name THEN Grade.
Name, Subject, Grade.
Adam, Chemistry, A
Adam, French, C
Bob, History, A
Bob, English, B
Chris, French, B
David, Chemistry, A

David, History, C

I don't know how you do that in the Access query builder but in SQL Proper it would be:
SELECT s.Name, r.Subject, r.Grade
FROM STUDENTS s
JOIN RESULTS r on r.StudentID = r.StudentID
ORDER BY s.Name, r.Grade
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top

University open days

  • University of Stirling
    Undergraduate Open Day Undergraduate
    Thu, 26 Sep '19
  • Heriot-Watt University
    Undergraduate Open Day - Scottish Borders Campus Undergraduate
    Fri, 27 Sep '19
  • Royal Holloway, University of London
    Undergraduate open day Undergraduate
    Sat, 28 Sep '19

It is really important for me to be involved in helping make my university better

Strongly disagree (15)
9.68%
Disagree (11)
7.1%
Neither agree or disagree (50)
32.26%
Agree (59)
38.06%
Strongly Agree (20)
12.9%

Watched Threads

View All