Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by silvionr
-
SQL - Invalid use of IS operator in query expression
Thanks for the quick reply, You’re right, once “IN(selectedCases)” is removed, it works, but not ecxatly the way it should. The string “selectedCases” contains the primary keys of the records I want to check for NULL Values, but aparently that’s the wrong way of doing it. In other words, I...- silvionr
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL - Invalid use of IS operator in query expression
Can anyone tell what is wrong with this select statement? Select Statement: *************************************************** SELECT [Primary Number] FROM [Vital Stats] WHERE [Title-D] IS NULL OR [First Name-D] IS NULL OR [Last Name-D] IS NULL OR [Inform Title] IS NULL OR [Inform first Name]...- silvionr
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Removing space if field is null
I am using Crystal Reports for Visual Studio .NET 2003 I have 3 fields: {Inform first Name} {Inform Middle Name} {Inform Last Name} There’s one space between each field. If the field {Inform Middle Name} is null then I have 2 spaces between {Inform first Name} and {Inform Last Name} and I...- silvionr
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
