Populating a table only with rows from a second table that exceed "X" amount

[CTHabitat]

I am working on a budget tracking sheet for a project I have half completed. We have a three tables relating to this project. We will call these "RQSTN" (table detailing bid amounts for all purchases exceeding $X (for this exercise, $X=$2.5K) that require bidding), "Charged" (all purchases from all accounts relating to the project), and "RQ_Blnc" (the difference between the bid amounts from "RQSTN" and the actual amounts spent from "Charged"). This is the table that is stumping me.

I would like to be able to extract any new entries exceeding $2.5K from "Charged" into "RQ_Blnc". From there, I need to be able to calculate the differences between "RQSTN" and "Charged". I should be able to easily do this myself. The real issue is only pulling the records that will exceed $2.5K. Tried to attach a couple of pictures as a visual, but it keeps telling me that the files are invalid, Sorry.

Thanks,

C

[Rabbit]

I have trouble understanding your question, it would help to see some sample data and results.

[CTHabitat]

Rabbit,

I have attached a zip folder with three screenshots showing a kind of step by step of what I am looking to do. Start with "BytesA".

Thanks, I hope this explains what I am trying to do better than written words.

I appreciate your help,

C

[zmbd]

CTHabitat:
Most of us will not open an attachment from a fairly new member as most of us are at work and there are some fairly strict policies regarding downloaded files.

Would you instead take a few moments and put together a table with your data. IF you will first click on the [CODE/] button in the formatting bar and then post your data between the two inserted code tags, your table spacing should be retained.

thnx