Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by banburyexperience
-
How can I make a value in a current field be the next value in another
Hi You Guys<br><br>I could really use your help on this one, it's driving me nuts! I have a field [Balance] this field has been arrived at from having an [currentlyInStock] field less [QtyReq] field. How do I make the [Balance] field become a [currentlyInStock] field for every...- banburyexperience
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Stock order system problem
I am building a database for my company and I want the system to be able to return the previous value of goods in stock, i.e. the Balance field now becomes the Goods In Stock field?<br><br>For example if Goods In = 6, Quantity Sold = 2, the Balance would be 4. If I wanted to carry out the same...- banburyexperience
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
calculating fields in a table
Given that a table has the following fields:<br><br>GoodsIn Stock, GoodsSold, Balance, and Re-orderLevel<br><br>How does one perform calculations i.e.<br><br>How can one display data showing that Goods sold reduces the goods in stock field, and notify the user when the Re-orderLevel sum...- banburyexperience
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
