Query Error 3075 Syntax Error

[jbailey4545]

having an issue I can't get past, below is the code:

Expr1: ConcatRelated("[PUB_fm_type].[client_id]","[PUB_fm_type]",[PUB_client].[first_name] & """")

I receive the error

Error 3075: Syntax error in string in query expression 'Brian'".

[PUB_client].[first_name] is test

[pbaldy]

Presuming that's the function from Allen Browne's site, check how to call it again. You've got the syntax wrong.

[orange]

Tell us about tables PUB_fm_type and PUB_client.
Ans also what you expect in the output. We only know what you tell us, and so far we don't have much.
You are missing leading quote for third parameter, but there may be more.

[jbailey4545]

Below is the full code:

SELECT PUB_fm_type.client_id, ConcatRelated("[PUB_fm_type].[client_id]","[PUB_fm_type]",[PUB_client].[first_name] & """") AS Expr1, PUB_fm_type.type
FROM (PUB_family INNER JOIN PUB_client ON PUB_family.person_id = PUB_client.client_id) INNER JOIN PUB_fm_type ON (PUB_family.person_id = PUB_fm_type.person_id) AND (PUB_family.client_id = PUB_fm_type.client_id)
GROUP BY PUB_fm_type.client_id, ConcatRelated("[PUB_fm_type].[client_id]","[PUB_fm_type]",[PUB_client].[first_name] & """"), PUB_fm_type.type
HAVING (((PUB_fm_type.type)=8));

does that help?

There ae multiple lines for PUB_fm_type.client_id that will have a different person_id

Trying to display one line for each pub_fm_type.client id with all the different person_id names

[pbaldy]

From Allen's site for the third argument:

If the foreign key field is Text (not Number), include quote marks as delimiters, e.g.:
"[ForeignKeyFieldName] = """ & [PrimaryKeyFieldName] & """"

yours

[PUB_client].[first_name] & """"

[jbailey4545]

Sorry but I am lost. I changed to

ConcatRelated("[client_id]","[PUB_fm_type]","[PUB_client].[first_name] """ & [PUB_client].[last_name] & """")

Still receive error and it displays [PUB_client].[first_name] as text instead of pulling data.

Error 3075: Syntax error (missing operator) in query expression '[PUB_client].[first_name] "Dunn"'

[pbaldy]

You left out the =. You also seem to be using 2 different fields.

[jbailey4545]

I have tried with and without. Here is what i have to make it simple.

I have table pub_fm_type with client_id, person_id, and type

Client_id person_id type
555 666 8
555 777 9
555 888 8

need it to pull
Client_id person_id type
555 666, 888 8

[June7]

I built a table with the 3 example records and some different ones for testing.

SELECT PUB_fm_type.client_id, ConcatRelated("[person_id]", "[PUB_fm_type]", "Type='8' AND Client_id='" & [Client_id] & "'") AS Expr1, PUB_fm_type.type
FROM PUB_fm_type
GROUP BY PUB_fm_type.client_id, PUB_fm_type.type
HAVING (((PUB_fm_type.type)='8'));