Show Total Pages Only Once

I have a query that contains a part number and the number of hours per day generated to complete each book. I need to develop a report that shows number of hours worked and total number of pages per book. Then I need to calculate the pages per hour. The problem I'm having is that when I try to run a query I can't seem to get the number of pages to show up only once per part number. The number of pages shows up for every day time was calculated. How can I accomplish this task?

Hi Katrina63,

Post the sql from your query and let me look at what you are trying to do.

lwells

SELECT qryNewTranslationProofreading.[BR #], qryNewTranslationProofreading.[ACT BR PG], qryNewTranslationProofreading.[DATE SHPD], qryTimeTable.Employee, qryTimeTable.Department, qryTimeTable.[Total Time]
FROM qryNewTranslationProofreading INNER JOIN qryTimeTable ON qryNewTranslationProofreading.[BR #] = qryTimeTable.[BR #]
GROUP BY qryNewTranslationProofreading.[BR #], qryNewTranslationProofreading.[ACT BR PG], qryNewTranslationProofreading.[DATE SHPD], qryTimeTable.Employee, qryTimeTable.Department, qryTimeTable.[Total Time]
HAVING (((qryNewTranslationProofreading.[ACT BR PG]) Is Not Null))
ORDER BY qryTimeTable.Department;

Hi katrina63,

From your post apparently the calculations are being performed in the qryNewTranslationProofreading query and not this query. I am also assuming that the calculated field [ACT BR PG] is where you have your question "The problem I'm having is that when I try to run a query I can't seem to get the number of pages to show up only once per part number". Being that the problem is not in this query, can you post me the sql from the query qryNewTranslationProofreading. Probably wouldn't hurt to post the qryTimeTable as well if it has any calculations in it.

lwells

SELECT tblTranslationProofreading.[BR #], tblTranslationProofreading.[ACT BR PG], tblTranslationProofreading.[DATE SHPD]
FROM tblTranslationProofreading
WHERE (((tblTranslationProofreading.[ACT BR PG]) Is Not Null));

SELECT tblTimeTable.[BR #], tblTimeTable.Date, tblTimeTable.[Start Time], tblTimeTable.[End Time], tblTimeTable.Employee, tblTimeTable.Department, Format([Start Time]-1-[End Time],"Short Time") AS [Total Time]
FROM tblTimeTable
WHERE (((Format([Start Time]-1-[End Time],"Short Time"))>"00:00"))
ORDER BY tblTimeTable.[BR #], tblTimeTable.Department;

Hi Katrina63

Which Field holds your Part Number and which Field holds your page numbers. And in which table is this data stored.

lwells