I am probably so annoyed that it must be easy, but I just can't figure it out!! I am trying to create a data entry form and want a field in there to automatically calculate the total of what is entered in the 13 fields that would have data entry in them. Sounds like a reasonably easy thing to be able to do, but I don't know why it isn't?? I just spent $90 on books for Access, and VB6, and neither of them can help me. I have the fields based on the table, as it did not work with the query. When I based the fields on the query, I could not add more records, but my total field in the query did work. I put in a text box field and had the expression to equal the query, but it displayed &name. I assume VB code would be the way to go, if someone could walk me through this I would be soo sooo happy!!!

THE GOAL: To have a total field that automatically updates after each entry of data on the form.