I cannot get the following code to work:

SELECT [Declares].[Name] INTO [Temporary Table]
FROM [Declares] in "C:\open.mdb" LEFT JOIN [new Trial] ON
[Declares].[Name] = [new Trial].[New Src Var]
GROUP BY [Name]
HAVING ((([new Trial].[New Src Var]) Is Null));

c:\open.mdb exists and contains the table declares with the appropriate variables.

[new trial] exists in the executing database, with the appropriate variables.

Syntax error in FROM clause is the error message.

Any suggestions? I'm probably doing something stupid, but for the life of me I can't see it.

Thanks
DerFarm