Query modification

endri81

Registered User.
Local time
Today, 01:50
Joined
Jul 5, 2010
Messages
121
Hi,
By using the following query

SELECT District.Id, District.Emer, Data_SDP.[Data e fillimit te tremujorit], Format$([Data e fillimit te tremujorit],"\Qq yyyy",0,0) AS Tremujori, Sum(Data_SDP.Mg3) AS [Low Dose], Sum(Data_SDP.Mcv3) AS Pop, Sum(Data_SDP.Depo3) AS Depo, Sum(Data_SDP.DIU3) AS IUD, Sum(Data_SDP.Cn3) AS Condoms
FROM District INNER JOIN Data_SDP ON District.Id = Data_SDP.Ref_District
GROUP BY District.Id, District.Emer, Data_SDP.[Data e fillimit te tremujorit], Format$([Data e fillimit te tremujorit],"\Qq yyyy",0,0)
ORDER BY District.Emer, Data_SDP.[Data e fillimit te tremujorit];


we get the result as attached.

How to modify this query for six months period time.
Regards
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    81 KB · Views: 98

Users who are viewing this thread

Back
Top Bottom