If Statements
how to look up numbers only?

Answer Question   |  March 17, 2012  8:02 PM
IF, IF statement

EmployeeNumber query in SQL Server 2008
I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it’s first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it’s first initial, first 6 characters of last [...]

Answer Question   |  June 21, 2011  7:25 PM
IF logic, IF statement, SQL Query, SQL Server 2008

Stuck on an IF statement in Lotus Domino
I need to get this statement so that it will only update when a new doc is created. I am having a problem with the IF statement and it is currently update ever doc even if it does have new records. I only wnat the new record(actionitems) to update the agent is below   Sub [...]

Answer Question   |  March 1, 2011  8:30 PM
IF statement, Lotus Domino, Lotus Notes administration

How to run a command within a CLP only during a specific time frame
I have a pgm that perfroms verious system checks and alerts me if there is a problem.  I would like to add an If statement to exclude some of the checks that fall between a certain time period and have it jump to a specific lable in the script to continue. thus skipping over the commands [...]

Answer Question   |  December 28, 2010  7:26 AM
AS/400, CL Commands, CLP, IF statement

How to pick a source for a subform in Access 2003?
I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A’s plainid the DB the user is in. To check the DB-A’s planid against DB-B’ plainid then use the [...]

Answer Question   |  November 29, 2010  2:13 PM
Access, Access 2003, Access 2003 forms, Access Database, IF statement, Microsoft Access subforms

C# how to: IF Statement
Hello guys, C# question here…Could I ask or is there better website? Regards

Answer Question   |  December 3, 2009  11:16 PM
C#, IF, IF statement, loop

How can I add an IF statement to a .php file
Hi everyone, I have a form that has 6 fields to be filled in by the user. I’m not too good at editing .php files, so I come to you here. Here’s my problem. Fields 1, 2,3,4 and 6 always gets filled in. but sometimes, field 5 will get filled in and if this is [...]

Answer Question   |  November 14, 2009  8:28 PM
IF statement, PHP, PHP Coding, Web development

How to subtract positive number from negative number in an IF string
Having trouble with knowing how to subtract positive from negative numbers in an IF formula. Also want to add a conditional formatting for all negative time in column H.

Answer Question   |  July 30, 2009  9:12 PM
IF statement, SQL

Using ‘IF’ statements in query/400
I need to create a work field that will be populated differently, dependin on a series of ‘If’ statements. Ex: If TMRPER = ‘M’, use TMRFRQ value. If TMRPER = ‘D’, then use TMRFRQ divided by 30, rounded to the nearest whole number. Any idea how to do this?

Answer Question   |  June 24, 2009  8:02 PM
IF statement, Query/400

If Statement isn’t evaluating out correctly
I am trying to learn VB.Net using VB Studio 2005 Express edition and a pretty good text book. I thought I was beginning to understand concepts until this exercise came up – now I wonder… No matter what value I put into txtOrderTotal.Text, I get the same dDiscountTotal… This is ‘hand-fed’ code that is directly [...]

Answer Question   |  April 23, 2009  8:00 PM
IF statement, VB.NET, VB.NET 2005, VB.NET 2005 Express Edition, VB.NET Express Edition

Visual Basic If Then Statement
HELP! I normally don’t write code or develop databases but I am trying to build a MS access database. I have one table (departments) with a list of departments and one table (112) with department, question text and question answer columns. I am trying to build a form where user selects department from drop down, [...]

Answer Question   |  January 8, 2009  9:53 PM
IF statement, IF Then Else, Visual Basic, Visual Basic for Applications

Microsoft Access 2007: Using an IF statement
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do that? Something like if [...]

Answer Question   |  December 11, 2008  1:00 AM
Access 2007, Database programming, IF statement, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications

IF statement in AS/400 query
Can I use an if-type statement to return a different value? For example, i thought i would use define results fields to say if(lnt03=34,”advance”,”payoff”) liek I would in excel. of course this doesn’t work…

Answer Question   |  October 24, 2008  7:56 PM
AS/400 Query, IF statement