Misc Time

[Guest]

I have a database for tracking completed processes for a group of employees.
Employees enter one record for each process category that they complete,
along with the number completed. They also enter the amount of time they
spent on miscellaneous projects (MiscTime).

I am attempting to build a query that will calculate their daily production
as a percentage. In an attempt to keep things simple, I have made separate
queries that I plan to join for the end result. One query calculates their
total miscellaneous time (MiscTime), one calculates their total production
hours (ProcessTotal), and the third calculates their total hours worked
(HoursWorked). The problem is with the MiscTime query (shown below):

Field: Date Processor MiscTime Sum Of MiscTime
Table: ProdTable1 ProdTable1 ProdTable1 ProdTable1
Total: Group By Group By Group By Sum

When the query is run, the output shows a sum for each record that the
processor has entered. I need the output to show a sum of all MiscTime for
each date.

Ex: Current output
Date Processor MiscTime Sum Of MiscTime
10/18/2004 Sally 2.5 2.5
10/18/2004 Sally 3.0 3.0
10/18/2004 Sally 0.5 0.5
10/19/2004 Ruth 3.5 3.5
10/19/2004 Ruth 1.5 2.5

What I need:
Date Processor Sum Of Misc Time
10/18/2004 Sally 6
10/19/2004 Ruth 5

Suggestions please.
Thanks
Dlemarr

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try this in SQL window:

SELECT [Date], Processor, Sum(MiscTime) As MiscTimeSum
FROM ProdTable1
GROUP BY [Date], Processor

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQYLNKIechKqOuFEgEQJkZwCdH6B12Tbmv6bKoxUXEvilP6UnQaIAoI1e
1zv85FgtFPnbtJD4lRVQBKeA
=xqED
-----END PGP SIGNATURE-----

 

[John Spencer (MVP)]

Just drop the third column. It is forcing a new row for every time Misc Time is
a different value.