Search results

Thanks Paul - really enjoy working with Access and looking forward to learning loads of stuff from you experts! Cheers Steve

Guys Worked it out! the problem was, the first 2 IIf statements were arguing with each other, as IIf statement 1 had criteria less than 90 days between 2 dates, and IIf 2's criteria was if the current date passes the planned date which, in effect means the solution is still less than 90 days...

I've just checked Ranman, the [completeddate] field is definitely blank. As I mentioned above, the strange thing is, removing the first statement (so the formula does not put the planned date in the diary when the due date is within 90 days of the currrent date) makes the formula work ok -...

Thanks for your reply CJ, maybe that's the problem having text and date formats, so I will need to look at another way if this does cause issues. Yep, the planner should show "Overdue" if the assessment date has not been inserted into the field. So if the assessment due date was yesterday and...

Thanks Ranman - I've never used this function before so am trying it out. I have tweaked it to add my field names in but unfortuntely the "Overdue" statement still doesn't show, although the other 2 you put in ("90 day warning" and "working") are fine, so it must be something I am showing wrong...

Hi everyone I appreciate this type of problem has been covered many times, but am trying a query that I have not yet come across here. I have an assessment planner for my staff that predicts due assessments. The dates are predicted in a query, and are displayed in a form when the due date...

Hi everyone Really pleased to have found this forum as many problems I have had have been solved, and look forward to joining in.:)