Date Difference and Percentages

[sp1260]

I created a database to track the number of Open Records Request for the city. My manager would like me to provide stats on the number of requests process. I created a query to calculate the time lapsed and would like to calculate the percentage of requests less than 5 days to process. One problem I am having it when I run the query it is asking me for a parameter value.

Please help!
Sonya

DateDiff("d", [DateReceipt],[Completion_Date])

 

[vbaInet]

It would be useful for you to show us the SQL statement. Also tell us what the pop-up is asking for.

 

[sp1260]

Here i the SQL view:SELECT [Open Records].[Date Receipt], [Open Records].[Requestor], [Open Records].[Phone], [Open Records].[Completion_Date], DateDiff("d",[DateReceipt],[Completion_Date]) AS Expr1
FROM [Open Records]
WHERE (((DateDiff("d",[DateReceipt],[Completion_Date]))<5));

 

[vbaInet]

Use this:

SELECT [Date Receipt], [Requestor], [Phone], [Completion_Date], DateDiff("d",[DateReceipt],[Completion_Date]) AS Expr1
FROM [Open Records]
WHERE DateDiff("d",[DateReceipt],[Completion_Date]) < 5;

You didn't tell me what parameter value is popping up?