Calendar-style report

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---
--------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:

Users who are viewing this thread

Back
Top Bottom