RE: [MS_AccessPros] Conditions in Browne's ConcatRelated

I'm not sure how Allen's code works but the generic concatenate function at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html allows you to concatenate based on almost any field or fields.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: no_reply@yahoogroups.com
Date: Mon, 23 May 2011 20:47:32 +0000
Subject: [MS_AccessPros] Conditions in Browne's ConcatRelated

Is there a way to check for last names being the same as a condition for ConcatRelated? I would like to add a condition saying that if the last names are the same then the names would be joined.

Is this possible?

Thanks!
Connie

Currently, with your help John, I have the following query:

SELECT ListingContacts.ListID, ConcatRelated("[FirstName]","qContactsSellerandSellerSpLN1","ListID = " & [ListingContacts].[ListID],""," & ") AS Sellers
FROM ListingContacts;

SQL for qContactsSellerandSellerSpLN1:
SELECT ListingContacts.ListID, Contacts.FirstName, Contacts.LastName, ListingContacts.SellerTypeID, ListingContacts.Priority, IIf([SellerTypeID] Mod 2=1,[SellerTypeID],([SellerTypeID]-1)) AS JoinNbr
FROM Contacts INNER JOIN ListingContacts ON Contacts.ContactID = ListingContacts.ContactID
WHERE (((ListingContacts.SellerTypeID)<=8) AND ((ListingContacts.Priority)<=4));

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/