vik02
05-18-2007, 08:31 AM
Hi everybody,
I hope this posting finds you all well.
I have this Access 2000 DB (?test_Vacation?) to modify, which I am attaching, and unfortunately was not initially built by me. What this is, a customized Vacation/ Out-of-Office Database. And, basically I need to create Reports for them. Right now, there are couple of Reports; one of which is simply a Crosstab Query, which is still not showing the Data functionally. If someone can jump in and help me out, that?d be great - you will find the Word attch. (?Help?) helpful, for it provides more detailed/ specific Improvements that need to be made on Reports. I provided some general suggestions for you here:
You can create a Form: Each employee by Month block ? total for EX: May; better yet by Week.
By WEEK, I?d like to see: who?s Out/ who?s In (like the Matrix, but need to fix the dates there to Count - ?run by day?)
The reports there right now are not functioning properly
For Matrix Report, you may use a Tbl_CLNDR w/ all working/ Business days (so not to keep recreating them). Right now, where the dates are correlated, it shows Names and all days @ Top, whether OR not the Employees are there OR not - but I needto get a Range, so it would show in month for EX:
Only April days, because it would take from the Tbl_CLNDR, and where they correlate with somebody?s date, it would have 1 or 0. After this Form is clean, it would chose a Report, which needs to be able to run a Matrix and just don?t show days (Null) that are not being occupied in the calendar at all.
i. Right now the Matrix Form is done by the number of the month / Year/ to show that timeframe
You may think of other Reports to include, to be able to know ahead who?s going Out that ?Week? (currently an incorrect name, for it is more of a 7 days in a Month) ? please be my Guest, fire away with anything that you think might help my Calendar analysis.
To sum it up, for Weekly Report: you can count the number of the week, and then group by Week, as well as separate reports by Month/ Year, with total for Days please. If this info doesn?t help, the attached ?Help? zip should brief you with little insight. Hopefully you get the idea, and if someone could please simply tweak and make the existing or new Reports work.
Much of luck and thank you in advance,
Beginner.
I hope this posting finds you all well.
I have this Access 2000 DB (?test_Vacation?) to modify, which I am attaching, and unfortunately was not initially built by me. What this is, a customized Vacation/ Out-of-Office Database. And, basically I need to create Reports for them. Right now, there are couple of Reports; one of which is simply a Crosstab Query, which is still not showing the Data functionally. If someone can jump in and help me out, that?d be great - you will find the Word attch. (?Help?) helpful, for it provides more detailed/ specific Improvements that need to be made on Reports. I provided some general suggestions for you here:
You can create a Form: Each employee by Month block ? total for EX: May; better yet by Week.
By WEEK, I?d like to see: who?s Out/ who?s In (like the Matrix, but need to fix the dates there to Count - ?run by day?)
The reports there right now are not functioning properly
For Matrix Report, you may use a Tbl_CLNDR w/ all working/ Business days (so not to keep recreating them). Right now, where the dates are correlated, it shows Names and all days @ Top, whether OR not the Employees are there OR not - but I needto get a Range, so it would show in month for EX:
Only April days, because it would take from the Tbl_CLNDR, and where they correlate with somebody?s date, it would have 1 or 0. After this Form is clean, it would chose a Report, which needs to be able to run a Matrix and just don?t show days (Null) that are not being occupied in the calendar at all.
i. Right now the Matrix Form is done by the number of the month / Year/ to show that timeframe
You may think of other Reports to include, to be able to know ahead who?s going Out that ?Week? (currently an incorrect name, for it is more of a 7 days in a Month) ? please be my Guest, fire away with anything that you think might help my Calendar analysis.
To sum it up, for Weekly Report: you can count the number of the week, and then group by Week, as well as separate reports by Month/ Year, with total for Days please. If this info doesn?t help, the attached ?Help? zip should brief you with little insight. Hopefully you get the idea, and if someone could please simply tweak and make the existing or new Reports work.
Much of luck and thank you in advance,
Beginner.