Hi all gurus ! I'm a beginner in this scripting thing appreciate the help. I have a complicated calculation that i need to perform quite everyday. here is what i need to do to extract the info database name = dataA table name 1 = supplyinv table name 2 = productbalance table name 3 = sales now this is what i want is calculate all the supplyinv qty(sum) and sales(sum) with date specify then deduct the product balance = result i want. How I want to write the script???? but b4 that i need to update the sales from productbalance as p.balance is primary without duplicate for some row such as 'cat','unitprice' there r sm case the column is empty due to keyin error. TQ very much
It's not that difficult to make, but in order to create it, you need to provide some more information. First of all, I need the complete lay-out for the database tables (So including the column names for date, qty, and sales. And you need to explain that last sentence in some more detail, I don't really get it yet.