Query to get total hours prior to a specific date.

[ted.assur]

Hi there:

This query seems like it should be so simple, however since the date
field returns different dates, the sum grouping is not working (as
desired). What do I need to do to get this to return the sum of
hours...
SELECT Time.Hours, Time.Person, Time.ProjectID, Time.WeekStartDate
FROM Time
WHERE (((Time.Person)=[Person?]) AND ((Time.ProjectID)=[Project ID?])
AND ((Time.WeekStartDate)<=[WeekStartDate?]));

Thanks in advance!

[Jason Lepack]

SELECT Sum(Hours) AS TotalHours, Person, ProjectID
FROM [Time]
WHERE WeekStartDate<=[WeekStartDate?]
GROUP BY Person, ProjectID
HAVING Person=[Person?] AND ProjectID=[Project ID?];

The problem was probably that you were trying to include the date as a
group by when it should just be included in the where.

Cheers,
Jason Lepack

te*******@gmail.com wrote:

Hi there:

This query seems like it should be so simple, however since the date
field returns different dates, the sum grouping is not working (as
desired). What do I need to do to get this to return the sum of
hours...
SELECT Time.Hours, Time.Person, Time.ProjectID, Time.WeekStartDate
FROM Time
WHERE (((Time.Person)=[Person?]) AND ((Time.ProjectID)=[Project ID?])
AND ((Time.WeekStartDate)<=[WeekStartDate?]));

Thanks in advance!