Date Range Form

[beckie1234]

I need to create a form that a user picks between two date ranges that will run a query to total the number of minutes that each area on a particular line (line 1 or line 2) is down. That information needs to be put into a bar chart and then the user needs to be able to run another query about each particular bar to show what the reason were for the downtime in that particular area. In other words the user needs to be able to keep drilling for more information as they go. Can anyone give me an idea where to start?

 

[macca the hacke]

What information do you have already in your database, or are you building database from scratch?

 

[rainman89]

start with the query between dates
Select [DownTimeMinutesLine1],[DownTimeMinutesLine2] from [TableName] Having [yourdate] Between [Startdate] and [enddate]

then create chart based on that query
you need a nother query to select reason for downtime and either put that on a button on your chart, or find someother way to do it. not sure how u would want to

 

[beckie1234]

The table that all the information is coming from has the line the, the machine center, the categories and the minutes that the line is down. The users want to be able to pick a set period of time (which constantly changes) like 3-1-07 to 3-15-07 and find out how long each area was down (line, machine center, or categories). The data must be shown in a bar chart. I assume I will use buttons to run the queries each time but I don't know how to really make the time the first deciding factor