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

error in access

P: 1
when i'm create the sql statement, the error "the specific field'[Course]' could refer to more than 1 table listed in the FROM clause of your SQl statement. What it's means and how to i change that coding. This is my coding that i'm use:

Expand|Select|Wrap|Line Numbers
  1. IIf(([Course]="BDTVEC Higher National Diploma in Computing [HND]") And [Total Score 11]>79,"Distinction",IIf(([Course]="BDTVEC National Diploma in Computer Studies [ND]") And [Total Score 11]>84,"Distinction",IIf(([Course]="BDTVEC Pre National Diploma in Computer Studies [PND]") And [Total Score 11]>84,"Distinction",IIf([Total Score 11]>64,"Merit",IIf([Total Score 11]>49,"Pass","Referral")))))  AS [Grade 11]
Mar 8 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
The error is saying that you have the same field in two or more tables and it doesn't know which one to use. To resolve it, you just need to qualify.
Expand|Select|Wrap|Line Numbers
  1. SELECT table1.fieldName
  2. FROM table1, table2
Mar 8 '12 #2

Post your reply

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