Benjamin Bolduc
Registered User.
- Local time
- Today, 08:50
- Joined
- Jan 4, 2002
- Messages
- 169
Im stumped! I need to use a complicated formula on one of my forms to determine the balance of products Im keeping track of. I only have experience in Excel Formulas. Here's what I need...
-First I have all the product information on the top of the form, and the inventory entry information in a subform at the bottom. I have a 'Quantity In'and'Quantity Out' field in that subform with the 'Balance' field on the top. I make changes to most of the inventory on a daily basis. (They come and go very quickly)
-I need to be able to type in the 'Quantity In' and Quantity out' in the same record.
-It needs to take the balance from the previous record and add the values of the 'Q-In' and subtract the value of the 'Q-out'
-Then it needs to display that value in the 'Balance' text box control I have in the form.
-Basically my goal is to bring up the product's form, quickly type in how many of it I received and got rid of and have that balance shown on the form. If anyone can help me Id greatly appreciate it
-
-First I have all the product information on the top of the form, and the inventory entry information in a subform at the bottom. I have a 'Quantity In'and'Quantity Out' field in that subform with the 'Balance' field on the top. I make changes to most of the inventory on a daily basis. (They come and go very quickly)
-I need to be able to type in the 'Quantity In' and Quantity out' in the same record.
-It needs to take the balance from the previous record and add the values of the 'Q-In' and subtract the value of the 'Q-out'
-Then it needs to display that value in the 'Balance' text box control I have in the form.
-Basically my goal is to bring up the product's form, quickly type in how many of it I received and got rid of and have that balance shown on the form. If anyone can help me Id greatly appreciate it
-