Access Update Query

已完成 已发布的 Jul 6, 2006 货到付款
已完成 货到付款

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

工程 微软Access MySQL PHP 软件构架 软件测试

项目ID: #3627502

关于项目

2个方案 远程项目 活跃的Jul 7, 2006

授予:

dperlbergervw

See private message.

$25.5 USD 在1天内
(120条评论)
5.6

有2名威客正在参与此工作的竞标,均价$21/小时

alexandrualiu

See private message.

$17USD 在1天里
(11条评论)
3.6