I am trying to do something in an Access query. Let's say there is an amount of 30,000 in column A. I would like column A to have $28,900 and column B to have $1,100. Basically anything over $28,900 I want to be transferred into column B and I want column A to be recalculated. So if column A has $50,000, I want column A to be recalculated to be $28,900 and column B to show $21,100. I hope this helps. Thanks!