Recent content by unnamedplayer

I know. That is the logic I would like to implement. I was hoping there is a way to do that other than writing nested IIf statements in the Control Source property of the textbox where I want to display the value.

No, no, I know that. Problem is, I need to see how many days a resident was there between a given time frame. So for example, if the person moved in on 5/29/10 and moved out 7/30/10 and I wanted to see how many days that person was occupying a space for the period between 5/1/10 and 6/30/10 I...

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