I have a program I'm working on that does has a graph to show what is
the future estimate of production of eggs from a bunch of different
farmers.

The table I have is this:
CREATE TABLE `henbatch` (
`henBatch_ID` int(11) NOT NULL auto_increment,
`Barn_ID` int(11) NOT NULL,
`Quantity` int(11) NOT NULL,
`StartDate` date default NULL,
`SlaughteredDate` date default NULL,
`StartDateSet` tinyint(1) default NULL,
`Received` tinyint(1) NOT NULL,
PRIMARY KEY (`henBatch_ID`)
)

StartdateSet is there because of something that I was thinking should
work, but don't know anymore if it will.

What I need to do is to select from this table for future entries that
might not yet have been entered. I need to group weekly or maybe
monthly the estimated sum of hens that are still in production. In
another table the barn has the lifetime for the batch of hens. Can
someone give me a suggestion on how to do this? Can this be done just
with a select statement from this table? Any questions, please ask.
- It's hard to explain.

Thanks