Compare value in multiple date ranges

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
 
A

Allen Browne

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.)
 
Top