Displaying data after 30 days

[jefrat72]

I have created a database that is used to record the date a specific form called a dispositon is given to a case specialist. So it works like this a client comes into our organization, goes to Deptment A. Department A assigns this case to a specialist with form disposition. The date the case is assigned is recorded in the database (field is called DateToSpec). After 30 days if form is not returned the Supervisors want to know. So here is the question. How do I code it so after 30 days the data will show up in a report? I have queries created that breaks down the specialits into units and I run reports off of these queries. However these reports show all dispositions that have not been returned. They want to narrow that to only those that have exceeded the 30 day time limit. Thanks in advance

 

[jwindon]

The formula would be to find all the records where (should be a short date data type)

>=[DateToSpec] + 30


Put that in a query under the DateToSpec field in the grid on the criteria line

HTH

 

[jefrat72]

Thanks, I have tried that but it doesn't work. I have also tried using DateAdd function but to no avail. Do I have to create a form with code to filter data to show after 30 days old?