Results 1 to 3 of 3
  1. 11-17-2011, 08:34 AM #1
    ShadeRF
    ShadeRF is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    24

    Iif like

    I have a statement in my query like this:

    TotalNet: IIF(Brand Like "BRANDX" OR "BRANDY*", Formula1, Formula2

    However even if i have BRANDZ it still choose formula1. I assume this has to do with the OR statement but I'm not sure. How can I fix this? Thanks so much for your help.
    Reply With Quote Reply With Quote
  2. 11-17-2011, 08:49 AM #2
    hertfordkc
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    TotalNet: IIF((Brand Like "BRANDX") OR (Brand Like "BRANDY*"), Formula1, Formula2

    Does that work for you?
    Reply With Quote Reply With Quote
  3. 11-17-2011, 08:55 AM #3
    ShadeRF
    ShadeRF is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    24
    Yes, thanks for all your help on my recent posts!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums