Syntax error

[raphael99]

Can someone take a look?

SELECT DISTINCT tblAnagrafica.[Cognome Nome], TabellaPIP.DescrizionePIP, tblAnagrafica.[Tessera Sanitaria], ConcatRelated("TabellaJoinPIP.DataPIP","TabellaJoinPIP", "queryPIPRecenti", [IDAnagrafica] = " & tblAnagrafica.ID & " AND [IDPIP] = "  & TabellaJoinPIP.IDPIP, "[DataPIP]") AS DatePIP
From tblAnagrafica INNER Join (QueryPIPRecenti INNER JOIN TabellaPIP ON QueryPIPRecenti.Codice PIP = TabellaPIP. Codice PIP) ON tblAnagrafica.ID = QueryPIPRecenti.[IDAnagrafica]
ORDER BY
TabellaPIP.IDPIP;

It gives me syntax error... Thanks

 

[spikepl]

Not really.

Copy all this into the SQL view of the query designer and switch to design view. If it errors then build it up a bit at a time.

The query designer is a free syntax checker available to you at all times.

 

[JHB]

The problem is the below, so what is your intention:

ConcatRelated("TabellaJoinPIP.DataPIP","TabellaJoinPIP", "queryPIPRecenti", [IDAnagrafica] = " & tblAnagrafica.ID & " AND [IDPIP] = "  & TabellaJoinPIP.IDPIP, "[DataPIP]") AS DatePIP

 

[raphael99]

@JHB
Thanks.
Nevermind I was write a fault query.