Query Same Table Twice for Date Range Comparisons of Same Data

cft

Registered User.
Local time
Today, 09:30
Joined
Dec 31, 2001
Messages
52
Reportedly, IVR usage has dropped over time. I have a Date Range Query that pulls data for the range entered. I would like the user to enter time range (1) to compare to time range (2) from the same table and compare month to month, etc. Now the query shows the same time period data twice and does not prompt the user for the second set of parameters: "Between [Enter Start Date as X/XX/XX]AND[Enter End Date as Y/YY/YY]" for the comparison time period. Any and all help will be appreciated.
 

Users who are viewing this thread

Back
Top Bottom