Search results

Hi all, I am a total noob to access programming so I am hoping someone can help. I am trying to make a report that displays the total number of days someone has occupied a residence during a given time frame. My report currently displays a Move-In Date and Move-Out Date which is pulled from a...

Hi all, I need some help. Let's say I have a table that contains employees and another that contains trainings they should have completed. The trainings table has columns: TrainingID, EmpID, Title, DateCompleted I need to find all employees who have not completed a specific training. For...

Hello all, I have a table with a field called TestType. There are three types of tests that can be entered, I'll call them A, B, and C. What I need to know is if there is a way I can query the table to determine who has not taken all 3 tests (and which ones) For example, with a table like...

Hello all, I am trying to make a report based on a query but I need to do a little work with the results of the query to determine if they show up on the report. For example, my query returns rows with fields such as Name, Type and Date. I need to look at the Date field and say for example it...