Re: iif statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 15:03:25 -0600

Yes, that makes more sense.

Example:
IIf([DrawingStage]="New" And [JobValue]>1000.0,[JobInitiatedDate],
    IIF ([DrawingStage]="Shipped" And [JobValue]>1000.0,[ShippedDate],
        IIF ([DrawingStage]="Cancelled",[CancelledDate],
            IIF ([DrawingStage]="Released",[ReleasedDate],
))))

If your logic is more complicated, we'll need the entire possible scenario
list to help further. 

-- 
Wayne Morgan
MS Access MVP
"Joel Allen" <joelallen123@verizon.net> wrote in message 
news:pFNRd.32745$wc.31359@trnddc07...
> Whoops, I misphrased my example.  Ok let's say I want both of these to be 
> true.....
>
> if DrawingStage = New and JobValue > 1000.0 then output the 
> JobInitiatedDate.
>
> I hope that makes sense.  I'm just having trouble with the syntax in an 
> IIF statement.

Relevant Pages

  • Re: FindRecord Error
    ... which is why you're moving the focus. ... easier to use the DAO FindFirst command on the form's Recordset. ... field then the syntax would be: ... Wayne Morgan ...
    (microsoft.public.access.formscoding)
  • Re: Dynamically display combo box based on selection in another co
    ... causing an problem. ... Syntax to pass the combo box parameters ... "Wayne Morgan" wrote: ... > Loan Officer is in), not the value in the field. ...
    (microsoft.public.access.forms)
  • Re: Versions
    ... does not make sense to compare the versions of two different products if one ... Any version within our company has only had one change in syntax. ... So you might end-up in a scenario where you want to compare A with ... for a certain piece of equipment. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Formula in report and subreport
    ... Disregard. ... I don't think this will work in this scenario. ... Wayne Morgan ... MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: combine two expressions
    ... Wayne Morgan ... MS Access MVP ... > get the right syntax. ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)