1
  • If Statements

    how to look up numbers only?

    R123456s5 pointsBadges:
  • 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...

    Mmdmurphy30 pointsBadges:
  • 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 Initialize %REM  REFRESH...

    AMcAuley3105 pointsBadges:
  • 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 that do...

    lotofbad205 pointsBadges:
  • 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 data to fill a sub-form. If...

    Techexpressinc10 pointsBadges:
  • C# how to: IF Statement

    Hello guys, C# question here...Could I ask or is there better website? Regards

    Ak1bo78150 pointsBadges:
  • 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 the case I need an IF /else statement...

    TheFinder1,940 pointsBadges:
  • 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.

    WAT5 pointsBadges:
  • 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?

    HTLFTMP5 pointsBadges:
  • 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...

    Rbrown3805985 pointsBadges:
  • 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...

    Williams77710 pointsBadges:
  • 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...

    Servent15 pointsBadges:
  • 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...

    KPSTL5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following