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
    Dec 2003
    Location
    Minneapolis
    Posts
    21

    Re: expression what is my oversight???

    Originally posted by Chopper4116
    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
    I found it....nevermind

Posting Permissions

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