hockey8837
Registered User.
- Local time
- Today, 04:48
- Joined
- Sep 16, 2009
- Messages
- 106
Hello,
I'm currently creating a database in which I can enter information about plants and track not only species information but also planting requirements & growing conditions, bloom colors, pollinator information, and bloom time of year.
My question is this: the most important type of report I want to get out of this DB revolves around bloom time. I want to be able to show a month-to-month timeline showing which flowers/plants/trees will be in bloom; almost like a horizontal bar graph, a large list showing all flowers in db, & when the start and end blooming.
I started by just having a check box for each month, but I then realized I don't know how to tabulate a report to get the flowers to be organized in ascending order by bloom start period, rather than in ABC order. Now, instead of 12 check boxes, I have a 'bloom start' text box and a 'bloom end' text box. I don't need the date picker because I really just need month, I don't need more details than that. However, I'm still having the same report issue of getting them in ascending order according to month.
Any suggestions?
I'm currently creating a database in which I can enter information about plants and track not only species information but also planting requirements & growing conditions, bloom colors, pollinator information, and bloom time of year.
My question is this: the most important type of report I want to get out of this DB revolves around bloom time. I want to be able to show a month-to-month timeline showing which flowers/plants/trees will be in bloom; almost like a horizontal bar graph, a large list showing all flowers in db, & when the start and end blooming.
I started by just having a check box for each month, but I then realized I don't know how to tabulate a report to get the flowers to be organized in ascending order by bloom start period, rather than in ABC order. Now, instead of 12 check boxes, I have a 'bloom start' text box and a 'bloom end' text box. I don't need the date picker because I really just need month, I don't need more details than that. However, I'm still having the same report issue of getting them in ascending order according to month.
Any suggestions?