By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

access error #3125

P: 1
i'm creating a results table using data from RMS. Here is the SQL code:
Expand|Select|Wrap|Line Numbers
  1. 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]
  2. 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?
Aug 7 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
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.
Aug 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.