473,385 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

error in access

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
1 1136
Rabbit
12,516 Expert Mod 8TB
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

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

Similar topics

10
by: Shawn | last post by:
JIT Debugging failed with the following error: Access is denied. JIT Debugging was initiated by the following account 'PLISKEN\ASPNET' I get this messag in a dialog window when I try to open an...
7
by: Martin Strojek | last post by:
Hi, I have the following problem with developing some web site. I use Visual Studio 2003 to build a website. I tried Windows 2003 Server and switched now back to Windows XP with PWS but the...
0
by: Costi Stan | last post by:
Hello, I get all the time JIT Debugging failed with the following error: Access is denied. message when trying to my a webservice. MSDN say to add DOMAIN/ASPNET user to Debugging Users. I get...
2
by: bb | last post by:
when using the web deployment project to merge my aspnet assemblies i get an unusual error 'access to path denied' i double checked path looks ok, and gave everyone full perms on the folder and...
2
by: HelenWu | last post by:
I have two frames in index.html: <frameset cols="165,*"> <frame name="NCTnav" src="NCTnavHome.htm" scrolling="auto"> <frame name="NCTmain" src="http://www.yahoo.com"> </frameset> ...
1
by: daraboy | last post by:
I have a Web home page which allows the IIS users account IUSR_Svr01 to view the page. Each link on the home page allows access to a sub folder, the access to the sub folder is restricted by the...
7
by: sforsasi | last post by:
Hi, I'm trying a simple code to upload a file to the server. When I click to Upload I get the following error message: Error: Access to the path xxx is denied The folder in which I'm trying...
2
by: RAG2007 | last post by:
Hi, I'm running an ADP with SQL Server as back end. On a main form, my subform is coming up blank. When I was running as an mdb with no back end I didn't have this problem. I get an error "Syntax...
2
by: =?Utf-8?B?U2hhbQ==?= | last post by:
I am having the error when i execute my .net application i got this error. "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) ". Can anyone help me to resolve this error....
1
guillermobytes
by: guillermobytes | last post by:
im getting an error that i don't understand : Fatal error: Access level to Dumper_Regex_Url::_update() must be protected (as in class Dumper_Regex_Abstract) or weaker in...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.