A
Ann Scharpf
I have a data table. Right now there are four pertinent fields.
PPE Date
Function
Task
Total Hours
I would like to select records with date greater than 7/1/07. Then I'd like
to group by Function & Task and get the total hours for each pairing. In
other words, once the records are SELECTED, I'd like to ignore the PPE Date.
I get too many records to be useful if Access combines the date/function/task
fields for the grouping. I tried to use WHERE in the Total Row
My query is not allowing me to do this. I get an error:
You tried to execute a query that does not include the specified expression
'eBizHoursRecorded.PPEdate' as part of an aggregate function.
Is it possible to do this in a single query or do I have to use a subquery
to select the records and then do my total calculation?
Here's my SQL, just in case:
SELECT eBizHoursRecorded.Function, eBizHoursRecorded.Task,
eBizHoursRecorded.TotalHours
FROM eBizHoursRecorded
WHERE (((eBizHoursRecorded.PPEdate)>#7/1/2007#))
GROUP BY eBizHoursRecorded.Function, eBizHoursRecorded.Task,
eBizHoursRecorded.TotalHours
HAVING (((eBizHoursRecorded.Function) Not Like "gl*"))
ORDER BY eBizHoursRecorded.PPEdate, eBizHoursRecorded.Function,
eBizHoursRecorded.Task;
Thanks very much for your help.
PPE Date
Function
Task
Total Hours
I would like to select records with date greater than 7/1/07. Then I'd like
to group by Function & Task and get the total hours for each pairing. In
other words, once the records are SELECTED, I'd like to ignore the PPE Date.
I get too many records to be useful if Access combines the date/function/task
fields for the grouping. I tried to use WHERE in the Total Row
My query is not allowing me to do this. I get an error:
You tried to execute a query that does not include the specified expression
'eBizHoursRecorded.PPEdate' as part of an aggregate function.
Is it possible to do this in a single query or do I have to use a subquery
to select the records and then do my total calculation?
Here's my SQL, just in case:
SELECT eBizHoursRecorded.Function, eBizHoursRecorded.Task,
eBizHoursRecorded.TotalHours
FROM eBizHoursRecorded
WHERE (((eBizHoursRecorded.PPEdate)>#7/1/2007#))
GROUP BY eBizHoursRecorded.Function, eBizHoursRecorded.Task,
eBizHoursRecorded.TotalHours
HAVING (((eBizHoursRecorded.Function) Not Like "gl*"))
ORDER BY eBizHoursRecorded.PPEdate, eBizHoursRecorded.Function,
eBizHoursRecorded.Task;
Thanks very much for your help.