Results 1 to 4 of 4
  1. #1
    Nanuaraq is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    77

    Really complex IIf

    I am trying to produce a complex set of IIf statements within each other. the idea is to provide user with input on complex issues and what to be aware of in certain situations. I may do so by producing a number of IIf statements, possibly in separate queries, but I want to compress a lot of information in a single comprehensive user feedback expression.


    But there is a limit to how much text I can write, even when using the generator to make the expression. Is there a workaround to generate really long pieces of expressions, perhaps by putting the text provided as feedback to the user in a separate place, like in a separate table?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    There should be no need to make complex IIFs.
    use either a lookup table in a query,
    or if really complex, a function.

    do you have example?

  3. #3
    Nanuaraq is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    77
    A lookup table may be what I'm looking for. I'll check it out and see if I can make something basic work. Thank you.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You may get some ideas from this tutorial depending on your proposed complex iif.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Complex Relationships
    By Mozencrath in forum Database Design
    Replies: 4
    Last Post: 08-25-2014, 10:28 AM
  2. Complex (for me anyway) schema
    By fubofo in forum Database Design
    Replies: 4
    Last Post: 11-22-2011, 09:57 PM
  3. Complex Sort
    By Jojojo in forum Queries
    Replies: 7
    Last Post: 10-18-2011, 09:40 PM
  4. Complex query to me anyway
    By AndycompanyZ in forum Queries
    Replies: 3
    Last Post: 06-28-2011, 03:08 PM
  5. Help with complex 'IF' function(s) ...
    By Captain Database ...!! in forum Queries
    Replies: 4
    Last Post: 06-13-2011, 12:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums