Help in Reports

[devagupt]

In my Database i have a query from which i run a report. I have sorted a query . Below is the code . WHen i run the query , it works and displays the accumulated downtime for all lines in a given shift for a given week. When i generate a report though , it shows all the information in one day instead of splitting it into different days in a given week. Please help! If someone can help , i can send them the file as well.

SELECT tblDowntimeTable.Date01 AS Expr1, tblDowntimeTable.Shift AS Expr2, tblDowntimeTable.Line AS Expr3, Sum([Time in min]*0.0167) AS WeeklyDowntime
FROM tblDowntimeTable
GROUP BY tblDowntimeTable.Date01, tblDowntimeTable.Shift, tblDowntimeTable.Line
HAVING (((tblDowntimeTable.Shift)=2));

 

[lespaul]

This type of ordering and grouping is done at the report level. You may also get more specific information in the Access Report Forum703.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi