Em Andamento

Access data manipulation

This has had to be re-advertised...

I need a macro to manipulate data in an access database. I will send you a database sample to work on.

There are 2 tasks the macro needs to perform:

There is a field called assigned which is blank at the moment. I want the first 20% of all the records (there's typically about 2,000 records) (ordered by the record number field) to have the value 1 in the assigned field.

The second 20% of records should have the value 2

3rd 20% value of 3

etc etc up to 5.

Second part:

There are 3 fields which need to be combined into a google search string. The 3 fields are "company name", "type of business" and "city". There is a "website" field. For only those records in which the website field is blank the website field needs to be filled with a string which is of the form

[url removed, login to view];q=company+name+type+of+business+city&meta=

Please only bid if you can do this within the time that you state. Thanks.

Habilidades: Processamento de dados, Visual Basic

Ver mais: value city, up string, data processing business, data 0, moment, meta data, manipulation, manipulate, data visual, data n, data en, data an, c data, c access, business data, database search macro, number manipulation, blank fields, google form data, amp access, access form record, send data, macro data manipulation, data processing sample, data time

Acerca do Empregador:
( 54 comentários ) London, United Kingdom

ID do Projeto: #29452

Premiar a:

Nortus

I can do it in several hours. Very simple macro... So, send me you database, I fix it and after that you can pay me.

$30 USD em 1 dia
(11 Avaliações)
4.1

27 freelancers estão ofertando em média $64 para este trabalho

gaffapi

I can write a program on delphi which will do this. Support and further updates will follow.

$80 USD em 1 dia
(110 Comentários)
6.6
netcoder

Hi, I think I can do it:-)! Best regards, rentacoder:-)

$55 USD in 5 dias
(56 Comentários)
5.5
rajanlengde

will be done a soon as you provide db structure, acept and excorw here.

$30 USD in 0 dias
(29 Comentários)
5.2
ddumitrascu

Hi, I am ready to start. Thank You, Dan

$75 USD in 2 dias
(53 Comentários)
4.9
mlgrow

What you are asking about is an nth select function. I have written these before and would have no trouble writting this for you. mlgrow

$80 USD in 2 dias
(1 Comentário)
4.4
SOFTWAREALLIANCE

Hi Send me message

$50 USD in 100 dias
(1 Comentário)
4.0
ocherk

Hi I can do it. Regards.

$100 USD in 3 dias
(3 Comentários)
3.6
sureshmalankar

Please see pm for details.

$55 USD in 2 dias
(4 Comentários)
3.1
kidunix

Check feedback and PMB.

$80 USD in 0 dias
(3 Comentários)
3.0
softwareprabhu

Hello I am interested do do this job and looking forward for your reply... Thanks.

$100 USD in 7 dias
(4 Comentários)
1.9
ugumugu

Hi, If you want them coded in delphi it will take a few hours. Thanks

$60 USD em 1 dia
(1 Comentário)
1.8
campbeld

Which to choose? Select us because you will benefit from the fact we want to earn back our lost star.

$100 USD in 21 dias
(2 Comentários)
1.7
VladKuznetsov

Hello Sir, I'm Zend Certified Software Developer with 5 years of experience in software development. I have a greate experienced with MS Access + MS Excel + Crystal Reports + Visual Studio .NET (I was working with this Mais

$60 USD in 2 dias
(1 Comentário)
1.0
frosso13

Hi. I can do it and the result will be perfect. It is something easy for me. Please let me know if you accept my bid. Regards Frosso

$30 USD in 2 dias
(1 Comentário)
0.8
bissolutions

Please check PMB for Details. Regards, BIS Solutions

$75 USD in 2 dias
(0 Comentários)
0.0
seejee

hi get you project with bugs free, sir i'll give you project within committed date.. soon as posible

$50 USD in 5 dias
(0 Comentários)
0.0
vladag

Hello! I can do this in 5 hours, even faster. The macro is almost ready!

$30 USD em 1 dia
(0 Comentários)
0.0
UTStudios

I would develop an application with delphi which would allow you to do what you need.

$50 USD in 2 dias
(0 Comentários)
1.6
vcans

Dear Sir/Madam, We are boutique IT solution providing company that provide solutions and services to few USA companies. We a team of dedicated software professionals that provide quality service on time. We re Mais

$100 USD in 7 dias
(0 Comentários)
0.0
indriyum

Hi I can do it. Regards.

$30 USD in 5 dias
(0 Comentários)
0.0