Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

total a table to a field in another table

total a table to a field in another table

total a table to a field in another table

I'm rather new to access so any help will be greatly appreciated.

I have 1 table [EXPENSES] which lists all expenses for all people

john $12
pete $6
al $4
john $11
john $3

I have another table [PEOPLE] and I want their totals stored there

al $4
john $26
pete $6

How do I go about this?

RE: total a table to a field in another table

This is actually pretty simple to do, although I'm not sure how much you know about Access.  You were right in creating 2 tables.  I would create an tblEmployee table, with an EmployeeID field with autonumber data type, EmpLastName with text data type and EmpFirstName as text data type.  I would create a primary key on the EmployeeID field.  The second table I would call tblExpenses.  In this table I would have at least 3 fields, ExpenseID, which might be a purchase order number, EmployeeID as text data type and Expense as a currency data type.  Then I would would click on the relationships icon, add both tables,  and click the mouse on the tblEmployee.EmployeeID field and drag it to the tblExpense.Employee field and declare a one to many relationship.  Then I would create a form, first adding all the fields in the tblEmployee and then all the fields in tblExpense.  After you create the form/subform, add a text control to the tblExpense subform on the form footer and enter this formula in the text box: =Sum([Expense]).  I tried it and it works.  I hope I didn't confuse you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close