In my database I have a table thats called contacts and holds all the data for the contacts. In this I have a section that allows the user to enter a date for when they wish to call a certain user back.
I have made a query that shows all the people you need to phone today. But after today they disappear off the list of people that need to be called. I would like them to stay on the list until the user takes them off the list themselves. Because if they have a day off and miss someone on the list then when they get back in they'll never know they were on there because they'll have gone off it.
I'm currently using Date() in the Criteria section for my "Follow Up Date" field and this only shows today. Tomorrow these dates will be gone.
Does anyone know how to make them dates stay on there, even after today until the user takes them off.
Thanks in advance
I have made a query that shows all the people you need to phone today. But after today they disappear off the list of people that need to be called. I would like them to stay on the list until the user takes them off the list themselves. Because if they have a day off and miss someone on the list then when they get back in they'll never know they were on there because they'll have gone off it.
I'm currently using Date() in the Criteria section for my "Follow Up Date" field and this only shows today. Tomorrow these dates will be gone.
Does anyone know how to make them dates stay on there, even after today until the user takes them off.
Thanks in advance