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