Need some help on Query

[harky]

Hi,
I had 2 table, one contact student detail and another contain enrollment

tbl students contain
Student ID
Name
Address


Tbl enrollment
Student ID Subject
001 Maths
001 Science
002 English
002 Science

On my Query
I know how to do the linkup but is the way i want it to display like this in datasheet view? the main thing is the subject to display. need any code?
Student ID | Name | Subject(1) | Subject(2)

normal it will display like
Student ID | Name | Subject

 

[xenou]

I would encourage you not to display this way. For instance, it is very hard to know if there will be a need for Subject (1), Subject (2), Subject (3) ... and on and on (i.e., how many subjects ??, and how many columns ??) .

In general, you would never build forms, reports, or (certainly) tables in this way, and if there is a good reason to do so you can probably also find another good reason not to do so!

 

[harky]

hmm... thanks bro!~

I would encourage you not to display this way. For instance, it is very hard to know if there will be a need for Subject (1), Subject (2), Subject (3) ... and on and on (i.e., how many subjects ??, and how many columns ??) .

In general, you would never build forms, reports, or (certainly) tables in this way, and if there is a good reason to do so you can probably also find another good reason not to do so!