Hi,
I have got 10 Item and each item have their own InvIN, InvOUT and Balance. I use 10 query to divide all 10 of the item and calculate the balance of each of the item in their respective query.
N in the form i have created a textbox to show the Sum of the Balance when one of the item is choose from my Item Combo box in the same form.
For example: Item A have 3 record in it balance 10 ,20 and 30. So in the form i choose Item A from my Item Combo box. Thus, the Sum of the Balance textbox in my form would show 60.
How do i do it...??