Lookup Function - Can you sum records?

[CCBtx]

I have a General Ledger Table.

Record 1 is Cash, Account #: 1001000.

It has Fields:

Account

Beginning Balance

Debits

Credits

Ending Balance

The Debits are in another table. The detail debits for 1001000 could be 1 record or 20.

That table's structure is:

Account

Debit Amount

Credit Amount

How would I get the sum of the Debit Amount in table 2 represented as 1 number (the Debits field) in table 1?

For example, if table 2 is:

1001000 500 0

1001000 250 0

1103000 800 0

1103000 0 1000

...I would like to get 750 into the Debits field on Table 1.

I have created a relationship between the two tables via Account #.

Thanks,

Edited February 12, 2010 by Guest

[CCBtx]

Never mind. The sum function is what I am looking for.