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.

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