Presently I have an Access Data Base to keep a track of expenses that are coming out of various purchase orders. This is what I have so far in the data base:
PO # Invoice # Vendor PO AMONT Invoice Balance
123 123 ABC $200 $50 $200 -50= $150
123 456 ABC $200 $25 $150-25 = $125
123 657 ghu $200 $100 $125 - 100 = $25
456 870 klm $100 $105 $100 - 105 = -$105
789 309 tus $500 $400 $500 - $400 = $100
I know I will probably need to use VB, but I have not done VB since 2001. Please help. Note that a PO number has only one beginning balance even though it is listed on each line that has the same PO number in the PO amount column. Thank you.
PO # Invoice # Vendor PO AMONT Invoice Balance
123 123 ABC $200 $50 $200 -50= $150
123 456 ABC $200 $25 $150-25 = $125
123 657 ghu $200 $100 $125 - 100 = $25
456 870 klm $100 $105 $100 - 105 = -$105
789 309 tus $500 $400 $500 - $400 = $100
I know I will probably need to use VB, but I have not done VB since 2001. Please help. Note that a PO number has only one beginning balance even though it is listed on each line that has the same PO number in the PO amount column. Thank you.