Member Avatar for kodak

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
  • 94 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Reddy_Raghu
Member Avatar for Reddy_Raghu

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.