Help with Duplicate Output Alias Error 'Exp1'

Discussion in 'Access Queries' started by DBA PJ, Oct 25, 2016.

  1. DBA PJ

    DBA PJ

    Joined:
    Oct 25, 2016
    Messages:
    1
    Likes Received:
    0
    Hello, I am looking to get some help with this error on running a querry. I have deleted the duplicate Exp ad ensured that no alias is duplicated as well. I am not sure what I am missing.

    Here is my SQL View.
    SELECT [T Schools].School, [T DC].LastName, [T DC].FirstName, [T DC].MiddleName, [T DC].Gender, [T DC].SASID, [T DC].DOB, [T DC].[Grade level], [T DC].Homeroom, [T DC].Teacher, [T DC].Address, [T DC].[Parent/Guardian], [T DC].LivesWith, [T DC].EnrStatus, [T DC].[DOE 24 HomeLang], [T DC].[Ethnic Code], [T DC].ELLPStat, [T DC].[DOE 19 Low income status], [T DC].Free, [T DC].Reduced, [T DC].Paid, [T DC].[Monthly Payment], [T DC].[Amt Paid], [T DC].[Check # or Cash], [T DC].[School Code], [T DC].AM, [T DC].PM, [T DC].Fri, [T DC].[M/W], [T DC].[T/TH], [T DC].Transp, [T DC].Email, [T DC].[Phone 1 Name], [T DC].[Phone 1], [T DC].[Phone 1 HCW], [T DC].[Phone 2 Name], [T DC].[Phone 2], [T DC].[Phone 2 HCW], [T DC].[Phone 3 Name], [T DC].[Phone 3], [T DC].[Phone 4 Name], [T DC].[Phone 4], [T DC].[Alt P/U #1], [T DC].[P/U #1 Ph #1], [T DC].[P/U #1 Ph #2], [T DC].[Alt P/U #2], [T DC].[P/U #2 Ph #1], [T DC].[P/U #2 Ph #2], [T DC].Sibling, [T DC].[Media News], [T DC].[Media Web], [T DC].Allergies, [T DC].[Epipen?], [T DC].Medications, [T DC].[Give Meds], [T DC].[Medical Issues], [T DC].[S-Call Parents], [T DC].[Snow Notes], [T DC].[Tchr Recommend], [T DC].[Bus Stop], [T DC].[Bus Time], [T DC].[Transportation Notes], [T DC].[Middle ELL Tchr], [T DC].[Date Enrolled], [T DC].[Date Withdrawn], [T DC].[Reason for Withdrawal], [T DC].Notes, [LastName] & ", " & [FirstName] & " " & [MiddleName] AS lfm
    FROM [T DC] INNER JOIN [T Schools] ON [T DC].[School Code] = [T Schools].[School Code]
    WHERE ((([T Schools].School)="Whittier") AND (([T DC].EnrStatus)="Active"));

    TIA!
     
    DBA PJ, Oct 25, 2016
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. steve

    Duplicate output alias

    steve, Aug 9, 2003, in forum: Access Queries
    Replies:
    0
    Views:
    343
    steve
    Aug 9, 2003
  2. Frank Martin

    Help needed with alias table.

    Frank Martin, Jan 3, 2004, in forum: Access Queries
    Replies:
    6
    Views:
    96
    Ken Snell
    Jan 5, 2004
  3. jwrnana

    Duplicate Output, Alias

    jwrnana, Jan 3, 2004, in forum: Access Queries
    Replies:
    1
    Views:
    6,245
    Joan Wild
    Jan 3, 2004
  4. Bonnie

    Duplicate Output Destination

    Bonnie, Apr 6, 2004, in forum: Access Queries
    Replies:
    0
    Views:
    220
    Bonnie
    Apr 6, 2004
  5. rocco

    alias...don't alias at all

    rocco, Mar 25, 2005, in forum: Access Queries
    Replies:
    4
    Views:
    280
    Van T. Dinh
    Mar 27, 2005
  6. Brian
    Replies:
    0
    Views:
    5,030
    Brian
    Aug 20, 2005
  7. Paul
    Replies:
    4
    Views:
    716
    John W. Vinson
    Feb 24, 2009
  8. Mindy

    DUPLICATE OUTPUT DESTINATION ERROR

    Mindy, Apr 2, 2009, in forum: Access Queries
    Replies:
    2
    Views:
    435
    Mindy
    Apr 2, 2009
Loading...