ACCESS FEED: [MS_AccessPros] Pulling two different names in one query

Rabu, 27 April 2016

[MS_AccessPros] Pulling two different names in one query

I have the following tables:

tbl_People

peopleID PK

FirstName

LastName

MiddleInitial

PeopleType = Claimant or Respondent

tbl_mediation_log

MediationLogID PK

CaseNumber'

ClaimantID - Should link to tbl_People with PeopleType of Claimant

RespondentID- Should link to tbl_People with PeopleType of Responent

Facts

Case Note

I started on a query to try and pull it out:

SELECT tbl_mediation_log.MediationLog_ID, tbl_mediation_log.Case_Number, IIf(IsNull([tbl_People].[MiddleName]),[tbl_People].[LastName] & ", " & [tbl_People].[FirstName],[tbl_People].[LastName] & ", " & [tbl_People].[FirstName] & " " & [tbl_People].[MiddleName]) AS cClaimantName, tbl_people.Salutation, tbl_people.FirstName, tbl_people.MiddleName, tbl_people.LastName, tbl_people.Suffix, tbl_mediation_log.Claimant_Petitioner_Name_ID, tbl_mediation_log.Respondent_Name_ID, tbl_mediation_log.Case_Summary, tbl_mediation_log.Facts, tbl_mediation_log.Claimant_Case, tbl_mediation_log.Respondent_Case, tbl_mediation_log.TERO_Ordinance, tbl_mediation_log.Applicable_TERO_Ordinance, tbl_mediation_log.Remarks, tbl_mediation_log.Decision, tbl_mediation_log.Stipulated_Res_Claimant_flag, tbl_mediation_log.Stipulated_Res_Respondent_flag, tbl_mediation_log.CaseDate
FROM tbl_people INNER JOIN tbl_mediation_log ON tbl_people.PeopleID = tbl_mediation_log.Claimant_Petitioner_Name_ID;

I need to add this in:

]),[tbl_People].[LastName] & ", " & [tbl_People].[FirstName],[tbl_People].[LastName] & ", " & [tbl_People].[FirstName] & " " & [tbl_People].[MiddleName]) AS cRespondentName

But I need to pull the correct person out of the tbl_people.

Any ideas or even doable.

Thank you,

Art Lorenzini

Sioux Falls, SD

__._,_.___

Posted by: dbalorenzini@yahoo.com

Reply via web post

•

Reply to sender

•

Reply to group