Hi All,
I am fairly new to Access and only have limited coding experience (which I have had quite a bit of help with, so please be basic with any replies!!).
I am developing a database for use in my workplace which is a training company. I have a table called 'Reviews', which tracks the last completed and the next due learner review. I have managed to write code into the 'Review' form, which automatically populates the next due date based on the date of the last completed review. A learner will have a maximum of 30 reviews, so the table fields are laid out across the top as Review 1 Due, Review 1 Completed, Review 2 Due, Review 2 Completed and so on.
I thought it would be pretty straight forward to design a query which would bring up all learners with overdue reviews. I have used the expression <=Date() as the citeria in the 'or' row of the query design under 'Review 1 Due' and then next to this (on the 'or' row), Is Null under 'Review 1 Completed'. I have done this all the way along from 'Review 1' through to 'Review 30'. At first glance this seemed to do the trick, but on closer inspection, it is also bringing up learners with review due dates in the future. I think I understand the logic as to why this is happening (as earlier reviews i.e. Review 1 has an 'overdue' date) but as these have a completed date, why are these learners still showing as being overdue when their next review may not be due for another month??
Although I think I know why this is happening, I just cant seem to get my head around how to solve the issue. I am hoping it is something simple, but I am at a complete loss??
I would appreciate any help on this, but please keep it as basic as possible...I won't be offended!!
I am fairly new to Access and only have limited coding experience (which I have had quite a bit of help with, so please be basic with any replies!!).
I am developing a database for use in my workplace which is a training company. I have a table called 'Reviews', which tracks the last completed and the next due learner review. I have managed to write code into the 'Review' form, which automatically populates the next due date based on the date of the last completed review. A learner will have a maximum of 30 reviews, so the table fields are laid out across the top as Review 1 Due, Review 1 Completed, Review 2 Due, Review 2 Completed and so on.
I thought it would be pretty straight forward to design a query which would bring up all learners with overdue reviews. I have used the expression <=Date() as the citeria in the 'or' row of the query design under 'Review 1 Due' and then next to this (on the 'or' row), Is Null under 'Review 1 Completed'. I have done this all the way along from 'Review 1' through to 'Review 30'. At first glance this seemed to do the trick, but on closer inspection, it is also bringing up learners with review due dates in the future. I think I understand the logic as to why this is happening (as earlier reviews i.e. Review 1 has an 'overdue' date) but as these have a completed date, why are these learners still showing as being overdue when their next review may not be due for another month??
Although I think I know why this is happening, I just cant seem to get my head around how to solve the issue. I am hoping it is something simple, but I am at a complete loss??
I would appreciate any help on this, but please keep it as basic as possible...I won't be offended!!
