I need to set up a query asking for a specific Dept Number, such as a Number 3. that's easy enough I just put in [Enter Dept #]. but we also want it so if you just hit enter and not type a number you get all the Depts. I've tried using the Like command but the Problem is that when you type 1 you get 1, 10, 11 etc. any Ideas
Thanks.
Thanks.