473,386 Members | 1,864 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,386 software developers and data experts.

I know I am close, but not quite

158 100+
Hey Guys, Me again...

There is something missing in here that doesn't make it work quite fully work. I am trying to get three different levels of categories concatenating together but I still haven't got it right. The first value[InvCatName] is never Null, but the other two may be Null. How do I phrase the code so I can see the result correctly? thanks.

Expand|Select|Wrap|Line Numbers
  1. SELECT InvCategoriesT.InvCatID, IIf(IsNull([InvCatTypeName]),IIf(IsNull([InvCatTypeItemName]),[InvCatName]),[invCatName] & ", " & [InvCatTypeName] & ", " & [InvCatTypeItemName]) AS Category
  2. FROM InvCatTypeItemNameT INNER JOIN (InvCatTypesNameT INNER JOIN (InvCatNameT INNER JOIN InvCategoriesT ON InvCatNameT.InvCatNameID = InvCategoriesT.InvCatNameID) ON InvCatTypesNameT.InvCatTypeNameID = InvCategoriesT.InvCatTypeNameID) ON InvCatTypeItemNameT.InvCatTypeItemID = InvCategoriesT.InvCatTypeItemNameID
  3. ORDER BY IIf(IsNull([InvCatTypeName]),IIf(IsNull([InvCatTypeItemName]),[InvCatName]),[invCatName] & ", " & [InvCatTypeName] & ", " & [InvCatTypeItemName]);
Feb 10 '10 #1
1 1021
jaad
158 100+
Never mind Guys, I figured it out. It was my joins that were causing the problem.

One thing I can start seeing though... Since I been coming over this forum I've learned a lot and starting to see things in a whole new light, cheers
Feb 10 '10 #2

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

Similar topics

4
by: -DRB- | last post by:
Hi, I'm probably going to get harassed just for mentioning the unmentionable, but since I have if anyone could answer this question that would be much appreciated. As per the rather long...
1
by: Guy | last post by:
I have 4 images on a page and when someone clicks on one of them I open a secondary window and write a few lines to it describing the image. If they don't close that secondary window however, and...
13
by: James Franklin | last post by:
Hi, I have a number of databases in A2K, written on different machines with different installations of Office. I have found that compacting a database while it is open regularly fails, seemingly...
8
by: hyejin | last post by:
I have a problem with dynamic iframe and document.close() on Firefox. Below two files create a dynamic iframe by JavaScript. These two samples do not have any problems on IE. But, on Firefox, the...
3
by: Todd Jaspers | last post by:
Hey guys, I've developed a C# Web Form using Visual Studio 2005. I can't quite figure out how to exit the form though??? On my form, I have a button which says "CLOSE". I'd like for someone to...
1
by: nebulus | last post by:
I'm working on a web app that under normal circumstances will be happy with the Session_OnEnd event, but when a user leaves a page by closing the browser by either Alt+F4 or just hitting the "X",...
9
by: Beowulf | last post by:
I was having this problem: http://groups.google.com/group/microsoft.public.sqlserver.server/msg/e36e423972323378?dmode=source with it taking an inordinate amount of time to enumerate the...
5
by: jimmy | last post by:
Hi all, I want to capture the event when the browser's close button is clicked in an html page. I tried using the event.ClientX and event.ClientY property in the body unload event, and this...
4
by: joe fission | last post by:
This is a crazy little problem, and I am not quite sure where to start looking. This VB.Net app will run fine on two of my computers (which are very similar), except after moving from one form...
7
by: Sin Jeong-hun | last post by:
I have a dialog form which pops up from the main window using the ShowDialog() method. this dialog has no or button, and it has quite a lot of controls on it. Now, I want to close this dialog...
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: 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:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
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
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...
0
jinu1996
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...

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.