How to group the data that they were to each other?

Have a database with these columns:
8e36d1b6476240b59d24eb354073f003.png
I want to get number1, title, theme and idea for each other, and then to make grouping by subjectname. Something like this:

number1 1 title titlename theme themename idea ideaname

number1 2 title titlename theme themename idea ideaname

number1 3 title titlename theme themename idea ideaname

Subjectname subject1

Subjectname subject2

Subjectname subject3

Subjectname subject4

Subjectname subject5
June 26th 19 at 14:23
1 answer
June 26th 19 at 14:25
First you need to group the data BY GROUPand then sort the ORDER BY

Example:
SELECT number1, title, theme, idea 
 FROM units 
 GROUP BY number1, title, theme, idea
 ORDER BY number1 ASC

Find more questions by tags Microsoft AccessDatabasesSystem administrationInfographics