0

I have been given a report that is generated by running the following query from a macro
( slightly edited to simplify )and I have not had a great deal of experience with Access.

The report is grouped by Data.Type and sorted be Data.Date

SELECT DISTINCTROW 
Data.Type, 
Data.Date, 
Data.Code,
Data.Highest, 
Data.Comments
Data.Mins, 
Data.Criteria, 
Data.Mpc,
Locations.Colour,  
Locations.Street,  
Locations.HAA, 
Locations.Zone, 

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))
ORDER BY Data.Date;

I have been asked to sumarise Mins according to Zone within the report so I want to sum records contained in the query according to each zone and work on that data

Is this possible and what would be the best way to access this data?

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by Reddy_Raghu
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.