Improve company productivity with a Business Account.Sign Up

x
?
Solved

Cannot define field more than once

Posted on 2013-12-12
3
Medium Priority
?
2,407 Views
Last Modified: 2013-12-12
Hi,

I have a make table query with the below SQL

The error i get is "cannot define field more than once"

Whatis this and can i work around it?

Many thanks

SELECT [INPUT D2 DATA].*, [Calculation D2].*, [Calculation D2].[Overal RAG], [Calculation D2].[Product Risk decision], [Calculation D2].[Business Risk Score], [Calculation D2].[Score selection], [Calculation D2].[Recognised structure], [Calculation D2].LOB, [Calculation D2].Country INTO JoinedByClientType
FROM [INPUT D2 DATA], [Calculation D2]
WHERE (((Left([INPUT D2 DATA].[Customer Type],255))=Left([Calculation D2].[Client Type],255)));
0
Comment
Question by:Seamus2626
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39713784
Get rid of the asterisks (*) and select only those fields you need, taking care to select each field only once.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39713789
For starters, try completely taking out the [INPUT D2 DATA].* and [Calculation D2].*, and see if that gives you the results you need.  If not, start adding fields individually until you have all of the fields you need, again taking care to not double-select any fields.
0
 

Author Closing Comment

by:Seamus2626
ID: 39713874
thanks
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question