Hello All,
I have a simple question that I cannot find any guidance on either on the net or in books. I cannot find any VBA anything about "omitting", "excluding", or "isolating a value", anything...
My Boss, Mr. Jones wants me to use our employee database at work to select names at random using a query in Access. No big deal just make a query and run it, output it to a report, print it and done. But here is the catch he wants to make sure that his name never gets selected. I know what you are thinking just change the query criteria so that he doesn't get selected, ever. But that solution won't work in this instance... I want to use VBA to make sure that his ID never gets selected... This way if someone opens the query in design view they won't see him being excluded.
I attached a simple databse with a simple query. Any help on this would be great. Thanks.