how to create a transactions table

[Syphonics via AccessMonster.com]

In my data base there is purchases, expenses, wages, payments table.
Using the Form which I created, I tabulate the amount and put it into a field
into each of these table.

Example of the field call
Purchases, is "Total Amount"
Expenses "Total Amount"
Wages "Amount"
Payments "AmountPaid"

I would like to create a transaction table in which will add purchases,
expenses and wages into a field call "Debit" and Payments into a field call
"Credit"

 

[Jeff Boyce]

Two separate fields for "amounts"? That sounds like a spreadsheet!

How about one field for amount, and a second field for type (e.g., CR, DB)?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

In my data base there is purchases, expenses, wages, payments table.
Using the Form which I created, I tabulate the amount and put it into a field
into each of these table.

Example of the field call
Purchases, is "Total Amount"
Expenses "Total Amount"
Wages "Amount"
Payments "AmountPaid"

I would like to create a transaction table in which will add purchases,
expenses and wages into a field call "Debit" and Payments into a field call