Formatting Output from a query

[Gmelsofty]

Hello;
I have the following table structure for a students database:
Reg_No Name Class Subject ID Mark
14256 Clint A 100 67
14256 Clint A 101 60
14256 Clint A 102 80
67478 Silas B 100 74
67478 Silas B 101 81
67478 Silas B 102 45

- Note that I used two primary Keys; Reg_No and Subject ID.
- How can I present the above data in a query or a report as follows using either VBA or SQL? Incase other subject IDs are added the sql should take care of it.

Reg_No Name Class 100 101 102 Subject ID x
14256 Clint A 67 60 80 --
67478 Silas B 74 81 45 --

Thanks.

 

[plog]

Most likely a cross tab query: https://support.office.com/en-us/ar...cc8-ba60-2cd8484667e8?ui=en-US&rs=en-US&ad=US

Of course I count 6 column headers and only 5 columns of data, so you messed up posting data somewhere. Also, how come Subject and ID in your expected results just have dashes?

Next time use commas as delimiters:

Field1Name, Field2Name, Field3Name
Dave, 17, 12/31/2016
Sally, 34, 1/19/2016

 

[Gmelsofty]

Thanks so much let me try it out.