Results 1 to 5 of 5
  1. #1
    Bertrand82 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Posts
    48

    Expression to complex in query expression (switch)


    Hi,

    I get the following error message when running my query

    "Expression too complex in query expression "switch(..."

    Is there a way to solve this. I have about 100 words that need be switched out.

    Br Bertrand

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You probably hit a limit in the Switch function.

    What do you mean by 'switched out'?

    Maybe you need a table of values then join that table in the query.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Bertrand82 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Posts
    48
    Hi, Im importing 100 different values from an external database and need the data converted. I have about 100 values that need to be replaced.

    eg.
    cat=mjau
    dog=wow
    pig=honk
    and 100 more.

    is the a more suitable approach? maybe an external table which access uses where i can see original data in left column and the replacing data i right column?

    thanks. br bertrand

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What do you mean by 'external' table. Yes, a table with columns of original and replacement data. Just join this table to the imported data table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Bertrand82 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Posts
    48
    IŽll try this "table with columns of original and replacement data. Just join this table to the imported data table."

    I have found other threads describing how its done.

    Thank you!

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

Similar Threads

  1. Expression too complex
    By bandidom9 in forum Queries
    Replies: 5
    Last Post: 08-08-2012, 10:29 AM
  2. Expression to complex
    By Compufreak in forum Queries
    Replies: 5
    Last Post: 08-08-2012, 04:03 AM
  3. Expression too complex to Evaluate
    By cbh35711 in forum Access
    Replies: 4
    Last Post: 02-27-2012, 11:06 AM
  4. Replies: 3
    Last Post: 03-31-2011, 11:07 AM
  5. need help, expression is too complex?
    By ice673 in forum Queries
    Replies: 5
    Last Post: 02-15-2010, 09:03 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