How can I add and subtract transaction in one column

[smno2309]

Hello I am new with access, so I have a little idea about the software (started learning).

I have a query where I need have a column that will show the net transaction meaning: where it summarizes all deposits minus the sum of all (withdrawals, cheques and other payments)

I have the following tables:
Banks (ID/Name/address)
Account (ID/Number/Bank ID/Account type)
Customer (ID/ Name/ Address)
Transaction (Id/Account ID/date/Type ID/amount)
Transaction type (ID/Transaction types)

Thanks for all the help I can get

[Seth Schrock]

Does your Transaction Type table contain the information as to whether the transaction is a debit or credit? What query would this column be going in? Are you needing a line-by-line detailed query that has a total at the bottom? Without these (and possibly others) details, it will be difficult to provide a good solution for you. In general, there are usually several ways to any given thing. Which one is best for a particular situation depends on the situation.

[smno2309]

Thanks a lot Seth Schrock.
The transaction Type table only shows the name of the transaction, and the Transaction table shows the amount of each transaction. The query has to be a group by: by bank, by client, by month and by transaction type (cheque, deposits, and others). It does not have to be at the bottom (I forgot to mention that is have to be by client) by bad.

Thanks again

[Seth Schrock]

You would do yourself a favor if you added a field to your Transaction Type table to signify whether the transaction is a debit or credit. It makes this problem easier and it also makes it very easy to add new transaction types in the future without major design changes.

Do you need the query to show all the records, or do you just need the summary information? Also, with the fields you provided, there is no connection between the transaction and the customer, so there isn't a way to group by the customer.

[smno2309]

Excellent!!! Seth Schrock I try your suggestion to add a column and identify the transactions as debit or credit, and you were right It worked.

Thanks a lot

[Seth Schrock]

Glad to be able to help.