Access query to get monthly and quarterly report

[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

 

[BruceM via AccessMonster.com]

Reports are not interactive, so how would you be using the tabs?

Some more information is needed. What are the tables and relevant fields,
and how are the tables related? Is the sample data from a crosstab query, or
what exactly? Is the month/year data stored as dates, text, or what? Is it
stored at all, or are they fields in a table. If they are fields you should
rethink your design, as storing data in field names is not an effective
design practice.

 

[Anil B]

hi Bruce, thanks for the reply....

I'll get raw data from the access query, which i'll be using to create pivot tables in other sheets.

I have Sharepoint lists data which i am linking to Access DB as tables, and i am joining the tables to get the result set. Start date and end date are date fields in table. I have Jobs reting dates as start and end dates. and i want the job retiring date falls in the month i want to say yes otherwise no.
and similarly by quarterly report.

thanks...
Anil B



BruceM via AccessMonster.com wrote:

Reports are not interactive, so how would you be using the tabs?
07-Jan-10

Reports are not interactive, so how would you be using the tabs

Some more information is needed. What are the tables and relevant fields
and how are the tables related? Is the sample data from a crosstab query, o
what exactly? Is the month/year data stored as dates, text, or what? Is i
stored at all, or are they fields in a table. If they are fields you shoul
rethink your design, as storing data in field names is not an effectiv
design practice

Anil B wrote

-
Message posted via AccessMonster.co


Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Extreme Programming Refactored [aPress]
http://www.eggheadcafe.com/tutorial...e-78a6882dbe43/extreme-programming-refac.aspx

 

[BruceM via AccessMonster.com]

I have been away from this computer since Thursday afternoon, which is why I
didn't reply until now. What do you mean by "other sheets"? Are you
creating crosstab queries? If so, from what are you deriving the column
headers? That is, you are showing months and years as column headers, but
where are those month/year combinations coming from?

I expect you could use an expression along the lines of:

IIf([YourDate] >= [StartDate] And [YourDate] <= [EndDate],"Yes","No")

However, I can't picture just where that would go, as I don't really
understand the structure.

hi Bruce, thanks for the reply....

I'll get raw data from the access query, which i'll be using to create pivot tables in other sheets.

I have Sharepoint lists data which i am linking to Access DB as tables, and i am joining the tables to get the result set. Start date and end date are date fields in table. I have Jobs reting dates as start and end dates. and i want the job retiring date falls in the month i want to say yes otherwise no.
and similarly by quarterly report.

thanks...
Anil B

Reports are not interactive, so how would you be using the tabs?
07-Jan-10

Reports are not interactive, so how would you be using the tabs

Some more information is needed. What are the tables and relevant fields
and how are the tables related? Is the sample data from a crosstab query, o
what exactly? Is the month/year data stored as dates, text, or what? Is i
stored at all, or are they fields in a table. If they are fields you shoul
rethink your design, as storing data in field names is not an effectiv
design practice

Anil B wrote

-
Message posted via AccessMonster.co


Previous Posts In This Thread:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Extreme Programming Refactored [aPress]
http://www.eggheadcafe.com/tutorial...e-78a6882dbe43/extreme-programming-refac.aspx