Error message "Duplicate output alias 'Expr 1' is preventing me f.

Discussion in 'Microsoft Access Database Table Design' started by Guest, Oct 7, 2004.

  1. Guest

    Guest Guest

    Dear "Smarter than Me", (I really am not saying this sarcastically!),
    I live in Vero Beach, Florida, and have my hands full at the office just
    trying to get everything back together after Frances and Jeanne came to visit
    so please forgive me if I am asking a question that is too elementary. I
    simply do not have time to try to figure this out any further and I know that
    for many of you, it is a "walk in the park".
    I am getting an error message "Duplicate output alias 'Expr 1' which is
    preventing me from opening a form that I need to enter data in so I can print
    certain reports.
    The only person who could help me is on a 3 month sabbatical so If anyone
    could advise me, I would so appreciate it.
    Thank you for your consideration and wisdom on this!
     
    Guest, Oct 7, 2004
    #1
    1. Advertisements

  2. Guest

    Duane Hookom Guest

    Open the form in design view. Check the record source query of the report
    and/or row sources of combo and list boxes for Expr1's.
     
    Duane Hookom, Oct 8, 2004
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Dear Duane,
    Thank you for your reply. Sorry for the delay in answering but I came down
    with a virus Thursday afternoon.
    I found the record source query(ies) and I looked thru everything that I
    could think of but I cannot find anything that say "Expr 1".
    Your answer was great, but you are not dealing with an Access designer. Just
    a user. Could you tell me more specifically where to look for the "Expr 1"?
    Thank you, again, for your time and expertise.
    Office Olivia
     
    Guest, Oct 11, 2004
    #3
  4. Guest

    Duane Hookom Guest

    Maybe paste the SQL view of your form's record source into a reply so we can
    see it.
     
    Duane Hookom, Oct 12, 2004
    #4
  5. Guest

    Guest Guest

    Hi, Duane,
    I did find the two Expr 1's in the Address Book stuff but I don't know how
    to handle getting rid of one as it seems to have a query based on it.
    I know that this Address Book is a mess but I inherited it from the previous
    office manager. I would like to delete some fields...but that's another story
    and not particularly pressing today...
    I am pasting the SQL from the three places that I think the form is based
    on. Thank you for taking a look at it.
    Olivia
    (PS-I can't figure out how to rate your answers, but they are excellent and
    do give me HOPE!)
    -------------------------------
    qrySupportReceipts: Select Query
    SELECT AddressBook.[Mr/Mrs], AddressBook.FirstName, AddressBook.LastName,
    AddressBook.Company, AddressBook.MailingAddress, AddressBook.City,
    AddressBook.State, AddressBook.[Zip Code], AddressBook.PersonID,
    Support.Ministry, Support.Amount, Support.Date,
    qryYearToDateSupport.YearToDate, AddressBook.Country
    FROM (AddressBook INNER JOIN Support ON AddressBook.PersonID =
    Support.PersonID) INNER JOIN qryYearToDateSupport ON AddressBook.PersonID =
    qryYearToDateSupport.PersonID;

    ============================
    qryYearToDateSupport: Select Query
    SELECT Support.PersonID, Sum(Support.Amount) AS YearToDate
    FROM Support
    GROUP BY Support.PersonID;


    ===================

    qryAddressBook: Select Query
    SELECT AddressBook.PersonID, AddressBook.[Mr/Mrs], AddressBook.LastName,
    AddressBook.FirstName, AddressBook.Greeting, AddressBook.Spouse,
    AddressBook.Company, AddressBook.MailingAddress, AddressBook.PhysicalAddress,
    AddressBook.City, AddressBook.State, AddressBook.[Zip Code],
    AddressBook.Country, AddressBook.HisWorkPhone, AddressBook.HisExtension,
    AddressBook.HerWorkPhone, AddressBook.HerExtension, AddressBook.HomePhone,
    AddressBook.Fax, AddressBook.[EMail/Pager] AS Expr1, AddressBook.AddressType,
    AddressBook.DateEntered, AddressBook.Notes, AddressBook.TheExchange AS Expr2,
    AddressBook.LastInvite AS Expr3, AddressBook.NumberInvites AS Expr4,
    AddressBook.InviteNextPOD, AddressBook.Counselor,
    AddressBook.CurchAffiliation AS Expr1, AddressBook.ConferenceDate,
    AddressBook.WorkshopDate, AddressBook.PODDate, AddressBook.InternDate,
    AddressBook.InternName, AddressBook.SpecialSelect, AddressBook.TrainingReq,
    AddressBook.ChurchAffiliation
    FROM AddressBook
    ORDER BY AddressBook.LastName, AddressBook.FirstName;
    **********************************************************
     
    Guest, Oct 12, 2004
    #5
  6. Guest

    Duane Hookom Guest

    Change the sql of this query:
    qryAddressBook: Select Query
    SELECT AddressBook.PersonID,
    AddressBook.[Mr/Mrs],
    AddressBook.LastName,
    AddressBook.FirstName,
    AddressBook.Greeting,
    AddressBook.Spouse,
    AddressBook.Company,
    AddressBook.MailingAddress,
    AddressBook.PhysicalAddress,
    AddressBook.City, AddressBook.State,
    AddressBook.[Zip Code],
    AddressBook.Country,
    AddressBook.HisWorkPhone,
    AddressBook.HisExtension,
    AddressBook.HerWorkPhone,
    AddressBook.HerExtension,
    AddressBook.HomePhone,
    AddressBook.Fax,
    AddressBook.[EMail/Pager] ,
    AddressBook.AddressType,
    AddressBook.DateEntered,
    AddressBook.Notes,
    AddressBook.TheExchange,
    AddressBook.LastInvite,
    AddressBook.NumberInvites,
    AddressBook.InviteNextPOD,
    AddressBook.Counselor,
    AddressBook.ConferenceDate,
    AddressBook.WorkshopDate,
    AddressBook.PODDate,
    AddressBook.InternDate,
    AddressBook.InternName,
    AddressBook.SpecialSelect,
    AddressBook.TrainingReq,
    AddressBook.ChurchAffiliation
    FROM AddressBook
    ORDER BY AddressBook.LastName, AddressBook.FirstName;

    --
    Duane Hookom
    MS Access MVP


     
    Duane Hookom, Oct 12, 2004
    #6
  7. Guest

    Guest Guest

    WhooHoo! I can get into everything! How simple when you (you, not me!) know
    what you're doing! Almost everything is working "normally" again.
    My only glitch is that the receipt form no longer asks me for a "range of
    dates", so I can't print just the ones for this pay period. I don't remember
    deleting anything from the form but after two hurricanes, I am not sure what
    I've done lately! Any thoughts on that?
    You have been SO kind and encouraging. I really would like to take a more
    advanced course in Access as I feel it is a very powerful tool if I could
    understand it properly.
    Huge thanks,
    Olivia
     
    Guest, Oct 12, 2004
    #7
    1. Advertisements

Ask a Question

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.