Hi,
I currently have a query which shows me a reference, request type, date received, closed date and allocated date. I already have it set to only show open records but I need it to show me if the allocated date has been blank for more than a set number of days from the date received. Is this something which is possible. I am quite new to access so any help would be very much appreciated.
I currently have a query which shows me a reference, request type, date received, closed date and allocated date. I already have it set to only show open records but I need it to show me if the allocated date has been blank for more than a set number of days from the date received. Is this something which is possible. I am quite new to access so any help would be very much appreciated.