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
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
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.
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
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.
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!