Thesis statment help

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 RE: IsError Function jalbao (Programmer) (OP) 29 Oct 04 15:35 In a nutshell, the SELECT statement is a user defined expression. Meaning that I don't know which field(s) is a divisor. The fact that the user is able to create his/her own expression imply's that any expression is possible. Instead of making my own parser that will figure out what's going on with the expression, I thought it much easier to just trap for any error on the expression - I just mentioned "divide by zero" as an example. RE: IsError Function dhookom (Programmer) 29 Oct 04 15:40 I would use:

SELECT IIf(=0,0,/) AS Expr1
FROM A INNER JOIN B...
Duane
MS Access MVP
Ask a great question, get a great answer.
Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884 .
Ask me about my grandson, get a grand answer. RE: IsError Function jalbao (Programmer) (OP) 29 Oct 04 19:30 So I take it that no one knows how the IsError function works? RE: IsError Function MoLaker (Programmer) 29 Oct 04 19:39 As I understand it, IsError is a function, not an Access function.  I can't help either, but you might post the question on the forum. RE: IsError Function PHV (MIS) 29 Oct 04 19:43 Have you even tried the F1 key ?
IsError(expr) returns True when expr can be evaluated as an error number , ie a variant with VarType = vbError (10). Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 RE: IsError Function MoLaker (Programmer) 29 Oct 04 19:45 Sorry, I just noted it is also an Excel function.  But, I don't see how it could be applied in a Select statement from MS Access or JET. RE: IsError Function jalbao (Programmer) (OP) 29 Oct 04 20:06 If I run the following query in Access:

CODE SELECT IIF(ISERROR(4),"ERROR","NO ERROR")
I get a result set back of "NO ERROR"


CODE SELECT IIF(ISERROR(),"ERROR","NO ERROR") *Note that I removed the argument from the IsError() function.

I get the error message: "Wrong number of arguments used with function in query expression..."

I would assume then, that if IsError() is not a valid Access function, I wouldn't have received either of the results that I just mentioned.

For example -  I just ran the following query:
CODE SELECT IIF(IsFakeFunction(),"ERROR","NO ERROR")
I got an error message stating: "Undefined function 'IsFakeFunction' in expression."

Hmm.. I'm confused on this one :| RE: IsError Function PHV (MIS) 29 Oct 04 20:22 Try this:
SELECT IIF(ISERROR(CVerr(4)),"ERROR","NO ERROR") Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 RE: IsError Function jalbao (Programmer) (OP) 29 Oct 04 20:33 Returns error message: "Undefined function 'CVerr' in expression. RE: IsError Function jalbao (Programmer) (OP) 29 Oct 04 20:41 Same context, different topic...

What is the extent of error handling functions available to us? It would seem to me that there has to be some way to handle errors at runtime in an sql statement... don't you think? Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.
Cancel Red Flag Submitted Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Medieval Christians and Muslims were fighting exclusively for deeply held religious beliefs.

site design / logo © 2017 Stack Exchange Inc; user contributions licensed under cc by-sa with attribution required . rev

ElectraGuide is a tool that wants to help high school students: find a topic (see example topic questions?) create a good thesis statement (see an example?)

Learn more

thesis statment help

Thesis statment help

ElectraGuide is a tool that wants to help high school students: find a topic (see example topic questions?) create a good thesis statement (see an example?)

Action Action

thesis statment help

Thesis statment help

Action Action

thesis statment help

Thesis statment help

site design / logo © 2017 Stack Exchange Inc; user contributions licensed under cc by-sa with attribution required . rev

Action Action

thesis statment help
Thesis statment help

ElectraGuide is a tool that wants to help high school students: find a topic (see example topic questions?) create a good thesis statement (see an example?)

Action Action

Thesis statment help

Action Action

thesis statment help

Thesis statment help

Medieval Christians and Muslims were fighting exclusively for deeply held religious beliefs.

Action Action

thesis statment help

Thesis statment help

site design / logo © 2017 Stack Exchange Inc; user contributions licensed under cc by-sa with attribution required . rev

Action Action

thesis statment help

Thesis statment help

Action Action

Bootstrap Thumbnail Second

Thesis statment help

Action Action

Bootstrap Thumbnail Third

Thesis statment help

Action Action