ConcatRelated Help

[aog928]

I've searched and searched and have not found a solution anywhere so I decided to ask here, sorry if this has been answered before...



I've got two tables, OwnersTable and PropertyTable where a single "Owner" can own multiple "Property"

So here's what I've got...

SELECT NamesTable.Name, ConcatRelated("Property",”PropertyTable”,"OwnerIDx = " & “OwnerID”) AS Expr1
FROM NamesTable INNER JOIN PropertyTable ON NamesTable.OwnerID = PropertyTable.OwnerIDx;

I've tried this several ways, but get the same result... I get two consecutive input boxes "PropertyTable" and "OwnerIDx" and get an error code regardless of what I enter in them...

Thanks.

[June7]

The posted SQL shows two styles of quotation marks. How did that happen? VBA doesn't like the slanted marks.

Is OwnerID a number type field?

Try without the table join.

SELECT [Name], ConcatRelated("Property", "PropertyTable", "OwnerIDx=" & [OwnerID]) AS OwnerProperties FROM NamesTable;

Name is a reserved word - should avoid reserved words as field names.

[aog928]

I was copying and pasting from several sites trying to copy the code and may have copied the "slanted" quotes from there, creating a whole new problem...

Thanks again.

[June7]

Think my initial post was wrong so I edited. Might review it again.

[aog928]

Yes at first glance it looked like it worked, finally came back and copied your code and it magically worked, then I realized you had edited you post...

I edited my initial response to not confuse anyone else looking for a solution...

Thanks again...