Query

[NewtoSQL]

SELECT MAIN_DATABASE.FNAME, MAIN_DATABASE.MPROV, MAIN_DATABASE.STATUS, [STUDENT DATABASE].DESCRIPTION
FROM MAIN_DATABASE INNER JOIN [STUDENT DATABASE] ON MAIN_DATABASE.MEM_NUMBER = [STUDENT DATABASE].MEM_NUMBER
WHERE (((MAIN_DATABASE.MPROV)="ab" Or (MAIN_DATABASE.MPROV)="bc") AND ((MAIN_DATABASE.STATUS)="student") AND (([STUDENT DATABASE].DESCRIPTION) Not Like "FA1"));

The above query is giving me the following results:

MELISSA AB CM1
MELISSA AB EM1
LUCIE BC CM1
LUCIE BC EM1
LUCIE BC MS1
SHIRLEY BC CM1
SHIRLEY BC EM1
SHIRLEY BC MS1
KAREN AB CM1
DENNIS BC EM1
PAUL AB CT1
PAUL AB FN1

How do I get the query to show names & codes in column 1 & 2 once only?

Also, is there a way that I can get the info in column 3 to display this way: CM1, EM1, etc...on the same line for each student?

Thanks.