1
  • Access 2007 IIf function in a query

    Please excuse my noobness but I am new to Access and rarely work with it. How do I replace the data in 1 field with the data of another field, if any data exists in the 2nd field? I suspect IIf would be the best way but I get 'NewID: IIf([OffenderID]="0000000000000",[ForeignID],"0000000000000")' is...

    Riaane65 pointsBadges:
  • Access 2010 macros

    I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!="NO" THEN EmailDatabaseObject called "Reject Report". . . My problem is that after the macro completes it locks the table that was made...

    Danna15 pointsBadges:
  • Count IIF Statement?

    In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use...

    Twj21025 pointsBadges:
  • MS Access 2007 IIF expression

    I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it's pulling all records with all court dates that is greater than today's date. I want the report to show just the next court date for each client. Is there an expression can I use to show only the...

    BaMbI0530 pointsBadges:
  • DLookup or IIF statement?

    How do I update the value of one row with the value of a different row? i want to build an expression For example: I have 3 columns. If Column 1=C and C is Null, then I want the values for C in Column 2 to = 10000 (the value from Column 2 for A) and the values for C in Column 3 to = 22000 9the...

    Alexvalentina10 pointsBadges:
  • Expression Builder, Calculation confusion in Access 2007

    Ok I’m having trouble with this simple calculation.  I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or greater than...

    Phil12550120 pointsBadges:
  • Javascript code

    Hi, I'm looking for an IF function code,,, My condition is IF I TYPE THE WORD "MOD" in a CHAT BOX THEN I want this MOD WORD TO APPEAR IN GREEN COLOR. I would like to know the code which I can embed for this to happen? thanks!

    SaraKhan5 pointsBadges:
  • In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?

    I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable<br><br> IIF Product ID = 00#* or 497* then category name = Component<br><br>...

    As2301495 pointsBadges:
  • Trouble with IFF MS Access 2007

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe that I should be using the...

    Phil12550120 pointsBadges:
  • Still having trouble with IIF in Access 2007

    If I type in the criteria block Is Not Null [Br _extended="true" />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any value,...

    Phil12550120 pointsBadges:
  • IIf and showing all

    I want to show in my criteria that: IIf([Issues].[DataOrigin]=2,-1,( no criteria or (0 or -1)) If I use null instead of no criteria my result is wrong if I use (0 Or _1) in Iff function my result is same as -1 but when I use (0 Or -1) in query I have right answer. Anyway I would like to show...

    Hh13545 pointsBadges:
  • Access 2003 using IIf statement on a form

    I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for 'current grade' and a field for 'target grade'. I also have a field 'progress' in which I am using an 'IIf statement' to compare the two fields (to show either 'under...

    Malcplant35 pointsBadges:
  • MS Access IIF Statement

    I am pulling options from a table of "1", "2" or "3" and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below: =IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be...

    Jsweitzer15 pointsBadges:
  • MS Access IIF

    There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the different types of costs seperately...

    Keg5 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.

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

Following