second column

[ewart]

How to create a second amount column in access?

Thanks

 

[striker]

Not sure what you are trying to do or where you want to do it. Some more detail might help

 

[RV]

In order to understand your question:

can you be more specific?

RV

 

[ewart]

I have a database with these headers: account, sbu, agn and amounts. The amount column consist of both debits and credits. The reason I wanted to create a new column is so I can run a query to match debits and credits with these criteria's, same account #/ same sbu#/ same agn #.

 

[RV]

You should split up your table into two tables.
One table containing the accounts, one table containing account transactions.

Apart from this, the reason why you want to add an extra column is not valid.

You can use this basic query though for now:

SELECT Amount
FROM YourTable, YourTable AS YourTable_1
WHERE YourTable.account=YourTable_1.account
AND YourTable.sbu=YourTable_1.sbu
AND YourTable.agn=YourTable_1.agn;

being YourTable the name of your database table.

RV

 

[ewart]

Thanks I wiil try that