Jayz
ISP
- Feb 17, 2002
- 59
Hi All,
I just created a query in the query design grid that calculates the working days between 2 dates and then filters out anything less that 4 days by entering >4 in the criteria.
Days_Since_rej: deltadays([Date_Advised],Date())
The problem is when I run the query it takes about a minute before the results are displayed.
If I then remove the criteria(>4), it works fine.
Is there an alternative around this solution so I'm able to show results that are filtered?.
I just created a query in the query design grid that calculates the working days between 2 dates and then filters out anything less that 4 days by entering >4 in the criteria.
Days_Since_rej: deltadays([Date_Advised],Date())
The problem is when I run the query it takes about a minute before the results are displayed.
If I then remove the criteria(>4), it works fine.
Is there an alternative around this solution so I'm able to show results that are filtered?.
