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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. steve

    Duplicate output alias

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

    Help needed with alias table.

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

    Duplicate Output, Alias

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

    Duplicate Output Destination

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

    alias...don't alias at all

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

    DUPLICATE OUTPUT DESTINATION ERROR

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