access error #3125

[jingleheimer]

i'm creating a results table using data from RMS. Here is the SQL code:

SELECT [Edit Table].ID_Txt, [Edit Table].[Site ID], [Edit Table].[Policy Number], [Edit Table].[Line of Business], [Edit Table].[Site Limit], [Edit Table].[Policy Limit], [Edit Table].[Policy Premium], [Edit Table].[Policy Deductible], [Edit Table].[Year Built], [Edit Table].[Building Limit], [Edit Table].[Building Value], [Edit Table].[Other Struct Limit], [Edit Table].[Other Struct Value], [Edit Table].[Contents Limit], [Edit Table].[Contents Value], [Edit Table].[Loss of Use Limit], [Edit Table].[Original Construction], [Edit Table].Construction, [Edit Table].[Wind Coverage], [Edit Table].[EQ Endorsed], [Edit Table].[Wind Policy Deductible], [Edit Table].[Wind Site Deductible], [Edit Table].UserDefined1, [Edit Table].UserDefined2, [Edit Table].UserDefined3, [Edit Table].UserDefined4, [Edit Table].UserDefined5, [Edit Table].UserDefined6, [Edit Table].UserDefined7, [Edit Table].UserDefined8, [Edit Table].UserDefined9, [Edit Table].UserDefined10, [Edit Table].[Limit Range], [Edit Table].[Limit RangeA], [QR01-01 Loc Data].*, [00 Pure Premium by Locnum].PERSPCODE, [00 Pure Premium by Locnum].[FFEQ All Regions EP Dist wLA EQSL wPP by], [00 Pure Premium by Locnum].[US EP Dist wLA by LOB, State (4-30-07)], [00 Pure Premium by Locnum].[EP Distributed (tornado + hail) by LOB,], [00 Pure Premium by Locnum].[FFEQ All Regions EP Dist wLA EQSL wPP by] INTO [Results Table]
FROM [Edit Table] LEFT JOIN ([00 Pure Premium by Locnum] RIGHT JOIN [QR01-01 Loc Data] ON [00 Pure Premium by Locnum].LOCNUM = [QR01-01 Loc Data].LOCNUM) ON [Edit Table].ID_Txt = [QR01-01 Loc Data].LOCNUM;

I have no idea why i'm getting this error. I've tried compacting the database, renaming the query, and have checked that nothing is spelled improperly in my query itself.

Anyone have ideas?

[NeoPa]

I can't speak for anyone else, but why you would expect anyone to go to any trouble to help when you've just dumped the SQL out in that mess is beyond me.

If you want help, start by taking YOUR time to display it in a more readable way.

Oh, and the description of the error wouldn't hurt either.