-
I need an Excel parameter prompt where the user can get a list of ALL items or only the KVI items. I've tried WHERE Unit = [Enter Unit] OR [Enter Unit] IS NULL. It works great in Access, but I get a syntax error in MSQuery. I tried using a single prompt in MSQuery, but when I input % wild card only...
-
Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
-
Omar Coincidentally, I posted this yesterday . It uses two and a 'between' operator, but will hopefully let you move forward. Let us know if it is still a problem.