Date Count Query

[woknick]

I have a table that includes client account information. I want to create a query that will select all account numbers where the last updated date is less than or equal to a number specified by the user.


Table (ClientRequests)

AccountNumber                 LastUpdated 
76869                         5/10/2005 9:49:38 AM
22151                         10/29/2005 10:35:23 AM

so for example: I would like to display all accounts where the differrence between todays date and the LastUpdated date is <=10. Where 10 would be a user defined number.

Hope this makes sence.

thanks in advance

 

[Sammy B]

Here is a dummy db that I created to do what you wish (I think)

Let me know if this helps.

Sam

 

[woknick]

thanks for the Help. Works great