Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Minneapolis
    Posts
    21

    Unanswered: expression what is my oversight???

    Expr1: IIf([TYPE]="ej","analog") Or IIf([type]="a","digital")

    So what I need is this select query to populate this field based on the designation in the type field. Whan I run this query now it populates with -1. Also replaced = with like and received same result... What am I missing

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select IIF(expression, trueValue, falseValue)
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •