Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Queries - duplicate field names

Status
Not open for further replies.
PJname

PJname

MIS
Jun 15, 2004
73
0
0
US
Question:

Is there a way to check for duplicate fields in a Microsoft Make table query?

Trying to perform a Make table and receive the following error:

Cannot define field more than once

I know that I can start over, but would like to prevent this due to complex criteria defined.

 
Sort by date Sort by votes
Might get more insight in the "Microsoft: Access Queries & Jet SQL" forum, but if you will post the SQL here maybe we'll gitter fixed!

10 is company, 11 is a crowd
 
Upvote 0 Downvote
Hello genomon,

I decided to start from scratch in creating my query and overwrite the query that I was having the problem with. I had a deadline to meet.

Thanks for responding.
 
Upvote 0 Downvote
Hope you do well - good luck!

10 is company, 11 is a crowd
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
105
SkipVought
S
jlr123
  • Locked
  • Question
Highlight (any) first text word that is a duplicate
Replies
2
Views
122
SkipVought
S
pmover
  • Locked
  • Question
MS Mac Office Single User License
Replies
3
Views
95
pmover
pmover
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
52
techie131
techie131
Andrzejek
  • Locked
  • Question
MS Teams zoom-in question 1
Replies
3
Views
91
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top