In relation to my previous question, i am trying to get a select count query to count records for last week, last month, last quarter and last year so i dont have to constantly change the dates in statement.
The attached statement works but will only give me the dates i specify, how can i get this query to ask for the dates in with a date calender popup?
Hope i explained myself properly.
SELECT Count([dbo_job list].[Job Number]) AS [CountOfjobnumber], [dbo_job list].[Engineer]
FROM [dbo_job list]
WHERE [opened date] Between #21/6/2009 00:00:01# And #27/6/2009 00:00:00#
GROUP BY [dbo_job list].[Engineer];