Re: [MS_AccessPros] Report not giving complete data

 

I expect there might be some records that don't have matching/related records in other tables. Have you tried looking at the full query records without the membership type filter? Have you tried changing the joins to LEFT or RIGHT joins?

Regards,

Duane Hookom

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, August 1, 2017 1:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Report not giving complete data

 

Hi all,

I have a report "List of Members For Printing Directory" having Record Source "List of Members Selective Membership Type Query" its SQL is:

SELECT [Members].[MembershipType], [Members].[MemberID], [Members].[GenderStatus], [Members].[Salutation_Detail], [Members].[SurName], [Members].[GivenName], [Members].[GivenName] & " " & [SurName] AS MemberName, Members.MembershipStartDate, tblCNIC.[CNIC Number], Members.DesignationSOC, tblJob.OrganizationDesignation, tblJob.Organization, tblAddress.[Postal Address], tblContactNumbers.TelephoneOffice, tblContactNumbers.TelephoneResidence, tblContactNumbers.FaxNo, tblContactNumbers.MobileNo1, tblContactNumbers.MobileNo2, tblContactNumbers.FaxNo, tblElectronicContacts.MemberEmail, Members.Working, tblAddress.MainCityName

FROM ((((Members INNER JOIN tblAddress ON Members.MemberID = tblAddress.MemberID) INNER JOIN tblCNIC ON Members.MemberID = tblCNIC.MemberID) INNER JOIN tblContactNumbers ON Members.MemberID = tblContactNumbers.MemberID) INNER JOIN tblElectronicContacts ON Members.MemberID = tblElectronicContacts.MemberID) INNER JOIN tblJob ON Members.MemberID = tblJob.MemberID

WHERE (((Members.MembershipType)=[Forms]![Dialog Members Directory Report]![cboMembershipType]) AND ((Members.Working)=True))

ORDER BY Members.GivenName, [Members].[GivenName] & " " & [SurName];

The Unbound Dialog Box "Dialog Members Directory Report" to open the report has Unbound Combo Box "cboMembershipType" its Row Source is:

SELECT DISTINCT [Membership Type].MembershipType, [Membership Type].MembershipTitle

FROM [Membership Type]

WHERE ((([Membership Type].MembershipType)<>"TM"))

ORDER BY [Membership Type].MembershipType;

Report is not giving or showing any error, i'm unable to trace why some data is missing from report.

Help required please.

(I've submitted this topic as it is most urgently required by my boss for printing of Society's Member Directory.)

Regards,

Khalid

 

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___