Hi all,
I'm using a query to count cases on a day. It could hapen that on that day there are no cases or the day is not yet (like running the query today and getting a 0 for tomorrow Friday)
I'm using this SQL:
Code:
SELECT Count(tbl_Reviews_case_list.[Case Status]) As [On Hold Tuesday]
FROM tbl_Reviews_case_list
GROUP BY tbl_Reviews_case_list.[Case Status]
HAVING (((tbl_Reviews_case_list.[Case Status])="On hold") And ((Count(tbl_Reviews_case_list.[On Hold (date)]))<#8/18/2015#));
The date is now hard coded, but, this will be changed later.
Greetings.