I agree with Bob about the table not being normalized. It looks like you just imported an Excel worksheet.
This is known as "Commiting Spreadsheet". This is quite common for new Access users to do because they see a table and it "LOOKS" like a spreadsheet.
As to your problem with the query..... you have based the form "frm Impoundement" on the table "tbl Impoundments". You need to use a query.
The first thing you need to do is make a copy of the dB.
I repeat - MAKE A COPY of the dB. Use the copy so you can throw it away without losing you dB.
Using the copy:
Now you need to remove any and all SPACES ( or replaces the spaces with the underscore) in object names - this means field names, table names, form names, query names.......
Close, then open the dB and try and add data to ensure that everything still works correctly.
All good??
OK, since you have based the form "frm Impoundement" on a table, this needs to be changed.
Create a query based on the table "tbl Impoundments". Name it "qryImpoundments" (NO spaces ).
Open the form "frmImpoundement" and click on the DATA tab. Change the RECORD SOURCE property to "qryImpoundments".
Save the form and close it. Now open the form. It should open with no errors. Try adding data to see if the calculations are correct.
Still good??
Next, Open the query "qryImpoundments" in design view.
For each calculated FIELD in the table, edit the same column in the query. You will be adding the calculation.
For example, the calculated field "45A S Gallons 1".
In the QUERY, the column would have
Code:
45A_N_Gallons 1: [45A_N_Finish1]-[45A_N_Start1]
(note I changes some of the spaces to the underscore and deleted the space after "Start")
For the next calculated field, the query column would be
Code:
45A_N_Gallons2: [45A_N_Finish2]-[45A_N_Start2]
Get the idea? Do this for every calculated FIELD in the table.
Once you have completed changing the calculated columns in the query, test the changes by entering data into the form.
Almost Last step is to delete the calculated fields in the table. EVERY calculated field. They should all be in the query now.
Last step: TEST. Enter data into the dB.