iff

  1. gheyman

    Access Question. Date Formula in a Query in the Field

    Expr1: DateDiff("d",[PDIR Due Date],Now()) I put this formula in my query and it works. But I would like to change it to an Iff statement where it only does this formula if [PDIR Completed] is blank. Can I do that?
  2. P

    Iff then, iff not function

    I am needing to compare multiple levels of information and need help! I'll provide the formula below I am trying to use. Iff [Work_Family] = "1211" And [Oper-ID] contains "1710-Assy", "Error", iff [Work_Family] does not = "1211" And [Oper-ID] does not contain "1710-Assy", "Error", "No Error"...
  3. T

    IIF statement code problems

    Hi to all the code monkeys out there. Looking for some guidance. Could someone please tell me why Access query has no problem reading and running. IIf([POCODE]='B06' And [R_SDATE]>Now() And ([R_SDATE]<[DUEDATE]) And [DUEQTY]>0 And ([RAISER]="DADAMS2" Or [RAISER]="BCOCHRAN " Or [RAISER]="BRICH "...
  4. Muttaki

    Repair of the Code, more than one OR IF also add the code.

    Hi frends , Title may have been a little strange, but the code of an application already written with the help of my friends need a revision. Thank you in advance about the possibilities of this help. Let us come to our, the following code, if any value in column J of "0" ZERO in the "Empty...
  5. Muttaki

    2 ayrı döngüyü bir butona bağlamak , Yada EĞER kullanarak bir kodu revize etmek.

    Merhaba arkadaşlar ; Konu başlığı biraz tuhaf gelmiş olabilir fakat ; daha önceden arkadaşlarımın yardımı ile yazdığım bir uygulamanın kodlarında bir revizyona ihtiyacım var. Bu konuda yardımcı olabileceklere şimdiden teşekkürler. Gelelim sadedimize ; Aşağıdaki kod eğer J sütunundaki...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top