Form

[Bill Frederick]

I have built my tables and have built a form. How do I make the last cell in the form perform a calculation?

Bill

[pbaldy]

Along the lines of a control source of:

=[FieldOne] + [FieldTwo]

[Bill Frederick]

I doesn't work.

[pbaldy]

I'm not sure how you expect anyone to help without posting exactly what you're trying to do and what you tried that "doesn't work".

[Bill Frederick]

Sorry,

I have built a database, put together my tables and have built a form that I use for record entry. My old database ( DOS ) will total the fields at "Total Fees" when I tab to it at the end of the form and gives a total for the fees in the form. I can do just about anything with Access, EXCEPT I can't make the last cell in the form ( Total Fees ) calculate and give me a total. I have tried, I even bought books, but to no avail. Any help would be appreciated.

Bill

[pbaldy]

Are you trying this in a table or on a form? You can't have calculated fields in a table, but it's quite common to do it on a form. Can you post the db?

[weekend00]

I didn't find a sum property in a textbox in form. I only find it in report.

you can put
=dsum("FEE","TableName")
in a text box to get the total, but need to refresh every time any number is changed.

[Bill Frederick]

I am trying to do it in a FORM. Tell me how to post the DB and I will.

Thanks,

Bill

[Bill Frederick]

I think I figured out how. ( I have NEVER used a Forum before ). Here it is.

Bill

[Bill Frederick]

Here is my DB

[pbaldy]

The attachment didn't make it. Make sure it's under the size limit. If you compact/repair then zip, it should be fine.

[Bill Frederick]

See if this works.

[pbaldy]

I don't see where you tried what I suggested. You do seem to be trying to store the calculated value. This has thoughts on why you shouldn't but gives a method to do so:

http://allenbrowne.com/casu-14.html

I would also point out that the table structure is not what is called "normalized". Having a field for each fee will cause you a lot of work down the road when somebody wants to add a new fee. Fees should typically be in a related table where you have a record (row) for each fee on an inspection. If you charged 3 fees for an inspection, there would be 3 records in that table for that inspection. Fields in that table would include the ID field from the main table, the fee type, and the amount.