Hello,

New to the forums here. I just got Access 2010 and using it to work on a small database to help me keep track of some oil field data. Would like some input if you guys don't mind.

I have a table called WellData, by itself it only has an autonumber field for a unique primary key and a field called WellID for the well number. The well number is unique to the lease, but another lease could have a well with the same number. It has two other fields, one is the LeaseName which is a drop down box that allows me to select which Lease from the LeaseData table that the well belongs to. And a checkbox that allows me to check which chemicals are used at that well which gets the data from a table called ChemicalData.

LeaseData uses autonumber for primary key, has two fields, Lease Operator and Lease Name.

ChemicalData uses autonumber as pk as well, has two fields called Chemical Name/Chemical Purpose respectively.

I'm sorry if that's a lot, but my first question is:

I need to keep track of each time a well fails, the date it fails, why it failed(bacteria corrosion, iron oxide corrosion, etc...) and I need to a monthly report on that.

What would be the best way of doing this?