Results 1 to 4 of 4

Thread: Query

  1. #1
    Join Date
    Jul 2003
    Posts
    43

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,931
    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.

  3. #3
    Join Date
    Jul 2003
    Posts
    43
    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.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,931
    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
  •