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

O

Office Olivia

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!
 
D

Duane Hookom

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.
 
O

Office Olivia

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
 
D

Duane Hookom

Maybe paste the SQL view of your form's record source into a reply so we can
see it.
 
O

Office Olivia

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;
**********************************************************
 
D

Duane Hookom

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


Office Olivia said:
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;
**********************************************************

Duane Hookom said:
Maybe paste the SQL view of your form's record source into a reply so we can
see it.

--
Duane Hookom
MS Access MVP


designer.
Just "Expr
1"? office
just came
to elementary.
I I
know which
is I
can
Click to expand...
Click to expand...
 
O

Office Olivia

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
 
Top