Displaying results for the current week so far.

[Workaholic]

I have a query that returns number the number of calls a certain office recieved where the office is a criteria, call types are criterion and the month and the year are criterion.

What I need is to display the calls by the current week only, even if the week is not yet complete.

Here is the enigma code-


SELECT dbo_helpdesk_calls.ID AS [Call ID], Format([date_raised],"Long Date") AS [Date], dbo_helpdesk_call_types.type AS [Call Type], dbo_helpdesk_calls.description AS [User Comment]
FROM (dbo_helpdesk_call_type_selections INNER JOIN (dbo_helpdesk_calls INNER JOIN dbo_helpdesk_offices ON dbo_helpdesk_calls.office = dbo_helpdesk_offices.ID) ON dbo_helpdesk_call_type_selections.call_id = dbo_helpdesk_calls.ID) INNER JOIN dbo_helpdesk_call_types ON dbo_helpdesk_call_type_selections.type_id = dbo_helpdesk_call_types.ID
WHERE (((dbo_helpdesk_offices.office_name)="Croydon") AND ((DatePart("yyyy",([dbo_helpdesk_calls.date_raised])))=2004) AND ((DatePart("m",([dbo_helpdesk_calls.date_raised])))=7))
GROUP BY dbo_helpdesk_calls.ID, Format([date_raised],"Long Date"), dbo_helpdesk_call_types.type, dbo_helpdesk_calls.description
HAVING (((dbo_helpdesk_call_types.type)="Groupwise/Email" Or (dbo_helpdesk_call_types.type)="New Joiner" Or (dbo_helpdesk_call_types.type)="Network (access to)"))
ORDER BY Format([date_raised],"Long Date"), dbo_helpdesk_call_types.type;

 

[pbaldy]

You'll find the appropriate date function to return the first day of the week here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210604