-
Query
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.
Last edited by NewtoSQL; 08-27-2003 at 04:16 PM.
-
How do I get the query to show names & codes in column 1 & 2 once only?
You can't with SQL statement, but you can do that in Report tool of Access, hide the repeating value.
-
Thank you for the quick reply, Skhanal.
Being new to Access, would you kindly give me the steps to follow to get the desired result with the report/tool function.
Regards.
-
Click on Report on left side and click on create new one using wizard, this will guide you through the process.
Once you have the report layout completed, you can set the property of the first column on the report to hide repeating value.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|