Compare value in multiple date ranges

  • Thread starter Thread starter ddpen
  • Start date Start date
D

ddpen

I want to compare a value (# of Errors) for 2 points in time [enter start
date] and
[enter end date] where the timeframes could be months or quarters. Basically
I want to have 3 columns: Types of Errors: Count of Parameter1: Count of
Parameter2. Help is appreciated.
thanks, dp
 
It's easy enough to design a Totals query that gives the count for one
period.

Then add a subquery that gives the count for the matching period.

If subqueries are news, see:
http://allenbrowne.com/subquery-01.html#YTD
The year-to-date example could illustrate how to get results from 2 periods
(current and year to date.)
 
Back
Top