Hello,
I have a report that is not showing like needed. I have a query that the report is based on. The query shows everything correctly. The problem I am having is the report is not showing the city and zip code correctly.
Here is the SQL of the query.
Code:
SELECT tblPersons.ChurchFK, tblPersons.FName, tblPersons.LName, tblPersons.Birthday, tblPersons.EMail, tblPersons.Anniversary, tblPersons.CellPhone, tblPersons.ActMember, tblPersons.ActVisitor, tblAddresses.AddressP, tblAddresses.AddressM, tblFamilies.FamilyName, tblAddresses.CityFK, tblAddresses.StateFK, tblAddresses.ZipFK, tblAddresses.HPhone, tblPersons.FamiliesFK, tblChurches.CName, tblChurches.AddressP, tblChurches.AddressM, tblChurches.CityFK, tblChurches.StateFK, tblChurches.ZipCodeFK, tblChurches.BPhoneFROM tblFamilies INNER JOIN (tblChurches INNER JOIN (tblAddresses INNER JOIN tblPersons ON tblAddresses.AddressID = tblPersons.AddressFK) ON tblChurches.ChurchID = tblPersons.ChurchFK) ON tblFamilies.FamiliesID = tblPersons.FamiliesFK
WHERE (((tblPersons.ChurchFK)=[Forms]![frmDirectory]![cboSelectChurch]));
The report shows the state correctly by showing the actual state. The City and zip code does not show correctly as it shows the ID number instead of the actual City / Zip Code. I am not sure why this is happening or how to fix it. Can someone please help? Thanks in advance.
--
Sincerely,
Clifford86