Access query to get monthly and quarterly report


Anil B

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


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

Query week, month, quarter 5
Quarterly Reports 3
Quarterly Reports 1
Month number in quarter 1
searching by month/quarter 1
Week, monthly, quarterly 2
Query Design for Monthly Report 4
Need Quarter Report 2