Summation of Data one Recordset, two filters

  • Thread starter Thread starter Robert Wetherill via AccessMonster.com
  • Start date Start date
R

Robert Wetherill via AccessMonster.com

I have a report attached to a query that returns hours and effective dates.

In my report I sum the hours at the end. In the same section, I want to sum
up a subset of these records, based on a specific date range. I want to use
the same recordset. I don't want to open up another recordset in VB to query
the sub set.

Resuts expected

Period Ending 9/2/05 Year to Date

Total Hours 25
397
 
Use:
=Sum( Abs([DateField] > #8/6/2005# AND [DateField]<=#9/2/2005#) *
[HoursField] )
 
Back
Top