Hi,
I want some vba codes to update Item table from sale table using criteria
fields to update are Item.QtyAvailable [Item Table] deduct sales quantity from Available Quantity in Item table
Customer.Account [Customer Table] debit this account of total Amount ordered from sales table
my sales table fields are [sales.QtySold, sales.Amount]
remember multiple items are ordered in one transaction with InvoiceID as criteria
----------------------------------------------------------------------------------------
#2
Append sales transaction to table ABC with vba code.
Please your help is important because i have been using query and sometimes it worked or sometimes not, I don't know why.
I want some vba codes to update Item table from sale table using criteria
fields to update are Item.QtyAvailable [Item Table] deduct sales quantity from Available Quantity in Item table
Customer.Account [Customer Table] debit this account of total Amount ordered from sales table
my sales table fields are [sales.QtySold, sales.Amount]
remember multiple items are ordered in one transaction with InvoiceID as criteria
----------------------------------------------------------------------------------------
#2
Append sales transaction to table ABC with vba code.
Please your help is important because i have been using query and sometimes it worked or sometimes not, I don't know why.