R
Rene
Good afternoon,
The query has the following six columns (Totals Query):
Column 1 (Group By) Month: Format([Begin],"mm")
Column 2 (Group By) Year: Year([Begin])
Column 3 (Group By) [Parent Company]
Column 4 (Sum) [Hours]
Column 5 (Expression) Hours Ytd:
DSum("Hours","tbl_Manhours","Format([Begin], 'mm')<= '" & [Month] & "'")
Column 6 (Where) [Begin] Between [Forms]![ Date Range]![Start Date] And
[Forms]![Date Range]![End Date]
The query provides a sum of the hours by month, for the months that fall
between the date ranges I specify on the parameter form. The problem is the
expression.
The expression provides a running (aggregate) total for each month. However,
it provides a total of ALL fields in the source table. I need the running
total to be based ONLY on the date ranges I specify.
For instance, if I specify between 01-01-09 and 06-30-09, It should
aggregate the totals for these months only. And not give me everything.
Please help.
Rene
The query has the following six columns (Totals Query):
Column 1 (Group By) Month: Format([Begin],"mm")
Column 2 (Group By) Year: Year([Begin])
Column 3 (Group By) [Parent Company]
Column 4 (Sum) [Hours]
Column 5 (Expression) Hours Ytd:
DSum("Hours","tbl_Manhours","Format([Begin], 'mm')<= '" & [Month] & "'")
Column 6 (Where) [Begin] Between [Forms]![ Date Range]![Start Date] And
[Forms]![Date Range]![End Date]
The query provides a sum of the hours by month, for the months that fall
between the date ranges I specify on the parameter form. The problem is the
expression.
The expression provides a running (aggregate) total for each month. However,
it provides a total of ALL fields in the source table. I need the running
total to be based ONLY on the date ranges I specify.
For instance, if I specify between 01-01-09 and 06-30-09, It should
aggregate the totals for these months only. And not give me everything.
Please help.
Rene