how to store records

[robina]

I have a table with with records that need to be captured for current and historical reporting. This is my table:

[Incident] [planned_end_date] [Report_Date}
1234 3/8/13 2/28/13
1234 3/8/13 3/1/13
1234 3/10/13 3/2/13
Then, on the next report dated 3/3/13 the incident may not be on the report because it is closed.

I need to be able to report on a count of incidents that meet different criteria at any point in time. I first made [Incident] and [planned_end_date] the PK but then when the [planned_end_date] changed it wouldn't be imported. If I have no PK all records will be imported and I would have the data I need but I think the table will grow too quickly (40 new records per day).

I appreciate any suggestions.

 

[plog]

I need to be able to report on a count of incidents that meet different criteria at any point in time.

Can you give an example? The less database jargon the better. Give me a specific question you want to know the answer to. For example: How many incidents occured that had a report date in February?

 

[robina]

Thank you for a quick response. Management has changed what they want to see so now I don't have this problem anymore. Thank you again.