0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Posted Topic
Select Locations.Zone, sum(Data.Mins) FROM Locations INNER JOIN Data ON Locations.Code = Data.Code WHERE (((Data.Date)>=["Enter Date From"] And (Data.Date)<=["Enter Date To]) AND ((Data.Code)<10000)) Group by Locations.Zone order by Locations.Zone ------------------- The above query will fetch the report by zone wise
The End.