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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing textbox value with values in named range 2
Macro for comparing columns and highlighting matching/differences 13
Calendar Logic: Recurring Dates 3
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
type mismatch error in macro in excel 0
Multi-level GROUP BY 8
Entering Report Parameters through a Form 2
Date Time decimal value help please 1

Top