How do i deal with this table

D

Dogdrake

Joined
Feb 21, 2006
Messages
1
Reaction score
0
I have a table which i would like to get some calculations from a querry
What is the best solution

I have a balance transactionAmount TransactionType and newAmount
Balance TransactionAmount TransactionType newAmount
200 50 1 ?
i want to calculate the new amount in the querry. the issue is if the transaction type is "1" i want to add the balance to the transactionAmoun.
If the transactionType is 2 i will like the perform a subtraction: balance -transactionAmount

How do i achieve this
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to perform a calculation where two operations are needed 1
Query to Find Records with only 1 transaction 6
Access Running Balance in Access 1
Balance Forward 4
A statement that automatically compile calculation 1
Bank Account Database Design 5
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Dynamic Headings in a crosstab query 2

Back
Top