Concatenate Question

[Ray Todd Jr]

I have having a hard time putting this concatenation query put together
using Duane Hookomj's function.

I have two tables:

taPROPERTY
PropertyID
ParcelNumber

taPropertyLiens
PropertyLiensID
PropertyID (FK)
LienHolderID (FK)

I am using the following query:

taPROPERTY INNER JOIN taPROPERTYLIENS ON taPROPERTY.PropertyID =
taPROPERTYLIENS.PropertyID

I am trying to concatenate the parcelnumbers for the individual lienholders.

Thanks,

Ray.

 

[Ray Todd Jr]

I got it work correctly by correctly writing the query to reference the
linking field in the concatenate function and using the where statement.

SELECT DISTINCT taPROPERTYLIENS.LienHolderID, Concatenate("SELECT DISTINCT
ParcelNumber from taPROPERTY INNER JOIN taPropertyLiens on
taProperty.PropertyID=taPropertyliens.PropertyID where
taPropertyliens.LienHolderID=" & [taPropertyliens.LienHolderID]) AS
ParcelNumber
FROM taPROPERTY INNER JOIN (taLIENHOLDER INNER JOIN taPROPERTYLIENS ON
taLIENHOLDER.LienHolderID = taPROPERTYLIENS.LienHolderID) ON
taPROPERTY.PropertyID = taPROPERTYLIENS.PropertyID;

Thanks,

Ray.