Small Access 97 Query/Function

I need an update function written for an Access 97 DB.

The DB has a table called dbo_imitimidx_sql. Each record has a TEXT field called "upc_cd" which is just a number, like "80738510772". I need a function to perform the following,

scan the table for any record where the field "mat_cost_type"='F' to assign the next sequential number to the UPC_CD field.

Here is an example :

item_no mat_cost_type upc_cd

Item1 F 80738510833

Item2 F 80738510832

Item3 F [null]

Item4 W [null]

Item5 F [null]

So this function should assign a UPC code of 80738510834 to Item 3 and 80738510835 to Item 5. It should Not assign a UPC Code to Item3 since its mat_cost_type <>"F" .

I am attaching a small sample database. Please note the actual table has over 11,000 records.

Thank you,


## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform


Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Veja mais: number function, function number, function - 1 to 1, steve w, steve s, query table, db query, upc php, access query table, update form access, access table query, access table query form, upc example code, access form record, php upc, access sample program, scan code update database, function sample, need upc, assign upc, null software, text database access, database sample program access, package access distribution, access package distribution

Acerca do Empregador:
( 198 comentários ) United States

ID do Projeto: #2958007

Concedido a:


See private message.

$12 USD em 1 dia
(28 Comentários)

3 freelancers estão ofertando em média $14 para esse trabalho


See private message.

$11.69 USD em 1 dia
(215 Comentários)

See private message.

$17 USD em 1 dia
(8 Comentários)