Search results

I am working on a database for work and I am still learning access. I need to create a query that will make a list of everyone who should be at work that day based on their job code that each person is assigned. Also though I need it to search another field and make sure that person hasn't...