Access Query

APandya 

First, we do not encourage storing calculated values in tables. That means you should not store "A" or "B" if they depend solely on the calculation from the "Buy" and "Sell" fields. 

BTW, what happens if the two are equal, i.e Buy and Sell are the same? The sample data seems to show that you are recording 0 and a non-zero value, which has other implications about the table design, actually.

You CAN, however, easily DISPLAY the calculation in a query or on a form or in a report. That's the proper way to do it.

Here is the syntax for such a query:

SELECT [ID], [Buy_Quantity], [Sell_Quantity], Iif([Buy_Quantity]>[Sell_Quantity],"A","B") AS [Account_Type]

FROM tblYourTableNameGoesHere

All of that said, if I interpret what is actually going on here, your table is not designed as it should be. (It looks more like a spreadsheet than a relational database table).

I would think THIS is a more appropriate design:

ID     TransactionType TransactionQuantity

1001      Buy                       5

1001      Sell                        2

2001      Buy                        4

2001      Sell                         6

and so on.

As a matter of fact, it looks very much like "A" and "Buy" mean the same thing (duplicate names) as do "B" and "Sell". Account Type, being duplicate, is redundant. And we don't encourage storing redundant values in a table.