Link to home
Create AccountLog in
Avatar of bezellvi
bezellvi

asked on

SQL/Access Start Date/End Date to Events

I have a data set that lists records including a Start Date and End Date for each. I would like to write a query that allows me to view what data was "active" on a specific date. i.e. if there were three records that were "active" on 11/16/12, I would like to count these records and sum some of the fields. What is the best way to do that?
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of bezellvi
bezellvi

ASKER

What if I want to list the count and sum of this data against a range of dates?
Define 'list the count' in terms my five year old would understand.
Attached is a sample.
EE-Sample.xlsx
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account