LEFT JOIN - Syntax error in FROM clause

[Igor]

Hello,

Please, can somebody help me out?

I'm getting a "Syntax error in FROM clause" message:

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
[Days], [From ACP].[Date Received]
FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];

I would appreciate all the help I could get.

 

[Igor]

Solved!

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
Days, [From ACP].[Date Received]
FROM [Deliverables Index] LEFT JOIN ([To ACP] LEFT JOIN [From ACP] ON [To
ACP].[ACP Reference Number]=[From ACP].[ACP Reference Number]) ON
[Deliverables Index].[Document Number]=[To ACP].[Document Number];

Thanks anyway!

 

[Michel Walsh]

There is a [To ACP] that should not be there, in the FROM clause:


FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];


Vanderghast, Access MVP

 

[Marshall Barton]

I'm getting a "Syntax error in FROM clause" message:

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
[Days], [From ACP].[Date Received]
FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];

You have an extraneous [To ACP] before the second LEFT JOIN

 

[Igor]

Thank you for your help!

 

[Igor]

Thank you very much!


--

igor

I'm getting a "Syntax error in FROM clause" message:

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
[Days], [From ACP].[Date Received]
FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];

You have an extraneous [To ACP] before the second LEFT JOIN