|
|
#Error on IIF Statement by
RaeRae
I have a query that I need to have return a calculation for me. I'm not sure
why I'm getting this error. Can someone help?
My fields have a Quantity, Unit...
|
|
2 |
116 |
|
|
#ERROR question by
Elmtree via AccessMonster.com
My formula:
Mid(,InStr(10,,": ")-1)
returns #ERROR if the value is blank, otherwise works fine. Any ideas how to
change my formula to get beyond the...
|
|
2 |
201 |
|
|
#ERROR question by
Elmtree via AccessMonster.com
My formula:
Mid(,InStr(10,,": ")-1)
returns #ERROR if the value is blank, otherwise works fine. Any ideas how to
change my formula to get beyond the...
|
|
2 |
141 |
|
|
#Error Results in Query by
Sherry N.
Hello,
I expect my query to return some #Error results b/c there is division
involved with 0. What I would like to do is create some kind of statement in
the...
|
September 1st, 2005 08:42 PM
by Ofer
|
2 |
183 |
|
|
|
|
9 |
118 |
|
|
#Error using Iif(x,0,Trim(Right([NettingGrp],20)) by
ragtopcaddy via AccessMonster.com
I get a #error returned if the following Iif statement is false:
Netting_Group: IIf(Trim()=0,0,Trim(Right(,20)))
Meanwhile, the following statement returns...
|
|
6 |
104 |
|
|
#Error using sub query by
Paul Dennis
I have 2 tables, one is the main data tables and another an audit table,
hence unless an activity has taken plan will not contain related records to
the main...
|
|
0 |
115 |
|
|
|
|
2 |
110 |
|
|
|
|
11 |
166 |
|
|
#Error when using Left Function by
Melinda
Hello,
I am trying to query out all but the last 3 characters of my contract name.
Here's the SQL I'm using:
SELECT Left(,Len(-3)) AS JobCode
FROM...
|
January 14th, 2005 01:15 PM
by Melinda
|
6 |
252 |
|
|
|
|
1 |
141 |
|
|
#Name error in Query by
BBC
Have read at least 100 posts re #name errors and still can't figure out
what's wrong with mine.
I have a master form (and table, both called "Client") that has...
( 1 2 3)
|
|
25 |
335 |
|
|
#Name? by
Thrinky
Hello,
I am trying to write a query that will provide me with any results that are
outside the range of 6.0 - 28.0. The result field is 'Text' and contain...
|
April 21st, 2005 03:39 PM
by Thrinky
|
2 |
96 |
|
|
#Name? by
Novice2000
Hi,
I created a query, and it seems to work fine and I am pulling data from it
to populate three reports. But, there is a weird thing that happens.
When I...
|
|
3 |
108 |
|
|
#name? by
datahunter
I have a querie which i get a final total but when i try to set my querie as
the record source for my report or a textbox in my form, when i try to run my...
|
|
1 |
116 |
|
|
#NAME? Error on Form by
Rob B.[_2_]
I want some form fields to automatically populate with data once another
field on the form is filled in. Specifically, I want a city and state to
fill in...
|
|
2 |
80 |
|
|
|
|
4 |
113 |
|
|
#Name? in text box with unique name by
Richard Hollenbeck
I think it is the GROUP BY not being equal to anything. I want totals of
all grades from each student. I don't know what to make studentID equal...
|
|
2 |
115 |
|
|
#NAME? problem by
Lisa
I have 2 tables with a relationship and enforced referential integrity
selected. When I use the Query in QBE or in a Form or Report it is hit and
miss. ...
|
December 2nd, 2004 03:09 PM
by Lisa
|
2 |
111 |
|
|
#Name? What does this mean? by
Novice2000
Seen this out here before, but I have never seen an answer. What is this. I
have entered all of the criteria for a query, and it opens up, but when I...
|
|
5 |
129 |