Access query to get monthly and quarterly report

  • Thread starter Thread starter Anil B
  • Start date Start date
A

Anil B

Hi,
I will require 5 tabs in the report. All reports should be able to use the same result set, but not all columns will appear in each report. They will just present the data differently.
for example: if month falls with in the start and end date should show yes otherwise No. Immediate help will be appreciated.. thank you in advance

Startdate Enddate Nov-09 Jan-10 Jun-12 Dec-12
12/11/09 6/30/2012 Yes Yes Yes No

Startdate Enddate Q3-09 Q4-09 Q2-12 Q4-12
12/11/09 6/30/2012 No Yes Yes No


Submitted via EggHeadCafe - Software Developer Portal of Choice
Active State VisualXSLT for .NET
http://www.eggheadcafe.com/tutorial...0-a1227145add9/active-state-visualxslt-f.aspx
 
Back
Top