Access Update Query

Concluído Postado Jul 6, 2006 Pago na entrega
Concluído Pago na entrega

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

Engenharia Microsoft Access MySQL PHP Arquitetura de software Teste de Software

ID do Projeto: #3627502

Sobre o projeto

2 propostas Projeto remoto Ativo em Jul 7, 2006

Concedido a:

dperlbergervw

See private message.

$25.5 USD em 1 dia
(120 Comentários)
5.6

2 freelancers estão ofertando em média $21 nesse trabalho

alexandrualiu

See private message.

$17 USD em 1 dia
(11 Comentários)
3.6