using math between two cells

[sunshine076]

I am working on a vb project that involves MS Access. My question is: Is there a way to divide the values of two textboxes and have it placed into a different column? Or is it wiser to be doing some of this in Excel?

 

[boblarson]

Can you write up an example of what the data would be before the split and then after the split?

 

[sunshine076]

what is going to be happening in the background is I have parts that will be comparing numbers with another cell and will increment. I will have a total quantity for a particular part and it would do something like this

Part 123 Lot qty 52 Increment 1
Part 123 Lot qty 52 Increment 2
Part 124 Lot qty 10 incr 1

This is what is will be doing in the end. Where I don't know what I am doing is here

Part 123 increment / lot qty = %of usage
Part 123 2 / 52 = 26%
I have text boxes called increment, qty, usage if this helps and in the end also it will be stored in an access db. Currently using vb studio for the forms and all the coding but once the user hits submit it will be stored in access. This is my goal.