Forum Discussion
lookup value in another column
1. Create blank query
2. Open Advanced Editor
3. Replace everything you see there with my code
4. Replace your_table with MASTER in the code
AlienSx Brilliant, that has worked perfectly, thanks so much for your help!
llamasarefun don't touch "Custom column" button, it's a big mistake. Have you seen that video? Your case is #2. Anyway, create new blank query, replace everything in it with my code and replace "your_table" in my code with the name of your query (MASTER?)
Hi AlienSx Yes I have watched the video thanks, very useful. I am putting the code into blank query and get the error
Expression.Error: The name 'Renamed Columns2' wasn't recognized. Make sure it's spelled correctly.
1. Create blank query
2. Open Advanced Editor
3. Replace everything you see there with my code
4. Replace your_table with MASTER in the code
llamasarefun my code does not have such "name".
AlienSx yes sorry my mistake!
So no errors now but I cannot see where the new column where i would see the results is?
llamasarefun rightmost column called "YN", located after column CR LOOKUP VALUE
AlienSx there is no additional column, CR LOOKUP VALUE is the last one still
AlienSx Brilliant, that has worked perfectly, thanks so much for your help!