hockey8837
Registered User.
- Local time
- Today, 13:17
- Joined
- Sep 16, 2009
- Messages
- 106
Hello,
I'd like to design a calendar-style plant bloom time report which will show months as the headers of columns and list the plant name across each month it's in bloom, like this:
.......May.......June........July........August........Sept......
-------------Plant 1----------
--Plant 2---
I really only need to look at what month the plant starts and ends its bloom time, so I have not used the calendar feature. Instead, the method I am currently using to track bloom start and bloom end is I have a table "Bloom Time" which tracks [PlantID], [MonthsID], [Bloom Start] and [Bloom End] through a Select control box in my Flower Details form. My "Months" table has Autonumber (column 1), Column 2 is an assigned # 1-12, and Column 3 is the associated month name (so I will get Jan (1), Feb (2), Mar (3)...etc.)
So, I need to figure out a way that I can get the above report and also also a report sorted by start month in which the flower, if it blooms from March-July, will show up in each month, not just in the march group since this is the start month. It may turn out that I need to restructure my method of tracking...which I'm ok with, I just need to know what to do.
I'm using Access 2007 and windows xp.
Thanks!
I'd like to design a calendar-style plant bloom time report which will show months as the headers of columns and list the plant name across each month it's in bloom, like this:
.......May.......June........July........August........Sept......
-------------Plant 1----------
--Plant 2---
--------Plant 3--------
----------------Plant 4-----------------
I really only need to look at what month the plant starts and ends its bloom time, so I have not used the calendar feature. Instead, the method I am currently using to track bloom start and bloom end is I have a table "Bloom Time" which tracks [PlantID], [MonthsID], [Bloom Start] and [Bloom End] through a Select control box in my Flower Details form. My "Months" table has Autonumber (column 1), Column 2 is an assigned # 1-12, and Column 3 is the associated month name (so I will get Jan (1), Feb (2), Mar (3)...etc.)
So, I need to figure out a way that I can get the above report and also also a report sorted by start month in which the flower, if it blooms from March-July, will show up in each month, not just in the march group since this is the start month. It may turn out that I need to restructure my method of tracking...which I'm ok with, I just need to know what to do.
I'm using Access 2007 and windows xp.
Thanks!
Last edited: