Access Update Query
$30-40 USD
货到付款
We will give to you a .mdb file that has a Table called tblDET.
Please write an update query for records where:
If QtyA is not Null, PkgA is set to “A?? and No Purchase is Unchecked
If QtyB is not Null, PkgB is set to “B?? and No Purchase is Unchecked
If QtyC is not Null, PkgC is set to “C?? and No Purchase is Unchecked
If QtyD is not Null, PkgD is set to “D?? and No Purchase is Unchecked
If QtyE is not Null, PkgE is set to “E?? and No Purchase is Unchecked
If QtyF is not Null, PkgF is set to “F?? and No Purchase is Unchecked
If QtyG is not Null, PkgG is set to “G?? and No Purchase is Unchecked
If QtyH is not Null, PkgH is set to “H?? and No Purchase is Unchecked
If QtyX is not Null, PkgX is set to “X?? and No Purchase is Unchecked
If QtyZ is not Null, PkgZ is set to “Z?? and No Purchase is Unchecked
If Qty1 is not Null, Pkg1 is set to “1?? and No Purchase is Unchecked
If Qty2 is not Null, Pkg2 is set to “2?? and No Purchase is Unchecked
If Qty3 is not Null, Pkg3 is set to “3?? and No Purchase is Unchecked
If Qty4 is not Null, Pkg4 is set to “4?? and No Purchase is Unchecked
If Qty5 is not Null, Pkg5 is set to “5?? and No Purchase is Unchecked
If Qty6 is not Null, Pkg6 is set to “6?? and No Purchase is Unchecked
If Qty7 is not Null, Pkg7 is set to “7?? and No Purchase is Unchecked
If Qty8 is not Null, Pkg8 is set to “8?? and No Purchase is Unchecked
If Qty9 is not Null, Pkg9 is set to “9?? and No Purchase is Unchecked
## Deliverables
1) Complete and fully-functional .mdb file that runs the update query.
2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Access 2003 on Windows XP
项目ID: #3627502