I use the expression below in a crosstab query and it works fine.
However, else where I would like to sum the four levels but on
ocassions some of the levels are null. Can anyone tell me how to use
the NZ function with this query to overcome the NULL entries or should
I be looking at some other function?
TIA - Ray
IIf([ReadingTotal]) Between 0 And 19,"Level 1",IIf([ReadingTotal])
Between 20 And 37,"Level 2",IIf([ReadingTotal]) Between 38 And
55,"Level 3",IIf([ReadingTotal]) Between 56 And 75,"Level 4")))) 2 8943
Say you normally have:
IIF ([blah] BETWEEN 11 AND 33, ...
but [blah] might sometimes be null.
If you want null values to >pass< the BETWEEN test:
IIF ( NZ ([blah], 1) BETWEEN 1 AND 9, ...
If you want them to >fail<:
IIF ( NZ ([blah], 0) BETWEEN 1 AND 9, ...
HTH,
TC
"Ray" <wa*****@xtra.co.nz> wrote in message
news:42**************************@posting.google.c om... I use the expression below in a crosstab query and it works fine. However, else where I would like to sum the four levels but on ocassions some of the levels are null. Can anyone tell me how to use the NZ function with this query to overcome the NULL entries or should I be looking at some other function?
TIA - Ray
IIf([ReadingTotal]) Between 0 And 19,"Level 1",IIf([ReadingTotal]) Between 20 And 37,"Level 2",IIf([ReadingTotal]) Between 38 And 55,"Level 3",IIf([ReadingTotal]) Between 56 And 75,"Level 4"))))
Sorry, I changed from 11..33 to 1..9 midstream! But you get the idea.
TC
"TC" <a@b.c.d> wrote in message news:1069561203.312013@teuthos... Say you normally have:
IIF ([blah] BETWEEN 11 AND 33, ...
but [blah] might sometimes be null.
If you want null values to >pass< the BETWEEN test:
IIF ( NZ ([blah], 1) BETWEEN 1 AND 9, ...
If you want them to >fail<:
IIF ( NZ ([blah], 0) BETWEEN 1 AND 9, ...
HTH, TC
"Ray" <wa*****@xtra.co.nz> wrote in message news:42**************************@posting.google.c om... I use the expression below in a crosstab query and it works fine. However, else where I would like to sum the four levels but on ocassions some of the levels are null. Can anyone tell me how to use the NZ function with this query to overcome the NULL entries or should I be looking at some other function?
TIA - Ray
IIf([ReadingTotal]) Between 0 And 19,"Level 1",IIf([ReadingTotal]) Between 20 And 37,"Level 2",IIf([ReadingTotal]) Between 38 And 55,"Level 3",IIf([ReadingTotal]) Between 56 And 75,"Level 4"))))
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Collin VanDyck |
last post by:
I have a basic understanding of this, so forgive me if I am overly
simplistic in my explanation of my problem..
I am trying to get a Java/Xalan transform to pass through a numeric
character...
|
by: DrTebi |
last post by:
Hello,
I have the following problem:
I used to "encode" my email address within links, in order to avoid (most)
email spiders. So I had a link like this:
<a...
|
by: Thomas Scheffler |
last post by:
Hi,
I runned in trouble using XALAN for XSL-Transformation.
The following snipplet show what I mean:
<a href="http://blah.com/?test=test&test2=test2">Test1&</a>
<a...
|
by: Luklrc |
last post by:
Hi,
I'm having to create a querysting with javascript. My problem is that
javscript turns the "&" characher into "&" when it gets used as a
querystring in the url EG:
...
|
by: johkar |
last post by:
When the output method is set to xml, even though I have CDATA around
my JavaScript, the operaters of && and < are converted to XML character
entities which causes errors in my JavaScript. I know...
|
by: Nathan Sokalski |
last post by:
I add a JavaScript event handler to some of my Webcontrols using the
Attributes.Add() method as follows:
Dim jscode as String = "return (event.keyCode>=65&&event.keyCode<=90);"...
|
by: Jeremy |
last post by:
How can one stop a browser from converting
&
to
& ?
We have a textarea in our system wehre a user can type in some html code
and have it saved to the database. When the data is retireved...
|
by: Arne |
last post by:
A lot of Firefox users I know, says they have problems with validation
where the ampersand sign has to be written as & to be valid. I don't
have Firefox my self and don't wont to install it only...
|
by: InvalidLastName |
last post by:
We have been used XslTransform. .NET 1.1, for transform XML document, Dataset with xsl to HTML. Some of these html contents contain javascript and links. For example:
// javascript
if (a > b)...
|
by: John Nagle |
last post by:
I've been parsing existing HTML with BeautifulSoup, and occasionally
hit content which has something like "Design & Advertising", that is,
an "&" instead of an "&". Is there some way I can get...
|
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,...
|
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$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |