Thank you, I appreciate your help.
Did I mention I have 170 wells to track with 4 different income types and 5
expense?
I want to create a lookup or list in the form so I can do the data entry and
simply pick the well, also with the month.
I have spent 10+ hours creating and deleting tables and forms because I am
missing something in my developing. This tracking I do is for a single
individual with WI and OR in all these wells. So manly its a lot of data
entry that I have done in the past in excel but it seems that access, if I
could figure it out, would serve the purpose better.

"Access Developer" wrote:

"lauralynne" wrote

All I need is a simple data base that contains
well names, and a form that allows me to enter
in monthly income and expenses on each well
in order to track and query.

Create a table, tblWell, with fields:
WellName, data type Text, size 255 character
WellYearOfReport, data type Number, Long Integer
WellMonthOfReport, data type Number, Long Integer
WellIncome, data type Currency
WellExpenses, data type Currency

You can create a Form, using the AutoForm feature

Use the PropertySheet of the Form to set it to DataEntry = Yes.

That's the simplest I can think of. But some enhancements for usability
would be to:

1. create a table of Well Names so the user could choose a well name using a
Combo Box, and avoid the possibility of typing errors... say typing "Adam
Cone 1" instead of "Adam Cone #1" for Well Name.

2. Add a validation rule of "=Year(Date) And 2100" or whatever year you
think are good limits to WellYearOfReport
3. Add a validation rule of "=1 And =12" for WellMonthOfReport

4. If you are comfortable with Input Masks, use an Input Mask of 0000;1;"__"
(that is, four underscores) for WellYearOfReport and 00;1;"__"
(twounderscores) for WellMonthOfReport

5. You will probably want a similar form for editing existing data... copy
the form with a different name and change its DataEntry property to "No".

6. If you are in the oil and gas well business, this is almost certainly
inadequate information for either internal reporting, or reporting to
royalty owners. I am minimally familiar, not expert, with the oil and gas
business, and not familiar at all with other types of wells and the
information that may be needed for those.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access



"lauralynne" wrote in message
...
I know that what I am trying to do is very simple, I have completed 3
levels
of training in access and am about as dumb as mud it seems.



.