Days Old Query Produces Inconsistent Results

[razorking]

I have a query that calculates the age in days of open orders. I am trying to produce a query that allows a user to enter a parameter - days old - as in how many days old do they want to look at data for open orders. I am getting very inconsistent results. Looking at the attached database, and using the query, enter values of 5, 50 and 100 to see what it is doing.

I have also tried to do this using a form, entering my desired "days old" value in a unbound text box on the form and passing that to the query, but it behaves no better.

Clearly I am missing something. I have another database that does something similar, it uses a form to pass the value to a query. And it seems to work accurately and dependably, but I cannot see a substantial difference between the two.

Please see attached and I appreciate any help.

 

[David Eagar]

try this one

 

[razorking]

David,

That seems to have done the trick. I don't understand what it was doing before but, hey, it works now.

Thanks for the long distance help.

 

[razorking]

Check that...I do see why it did not work before.