In Progress

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.

Just in case this isn't obvious: I just need a string produced for the second part. The string will be inserted into the database in the "website" field. I don't need to get into automating internet explorer to do automatic google searches etc!

Skills: Data Processing, Visual Basic

See more: www data processing, value city, up string, string processing in c, string manipulation c, data processing co, data processing business, data 0, moment, meta data, manipulation, manipulate , data, data website, data visual, data n, data en, data an, C# access, c data, c access, business data, access, access c#, database search macro

About the Employer:
( 54 reviews ) London, United Kingdom

Project ID: #29452

Awarded to:

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 in 1 day
(11 Reviews)
4.1

27 freelancers are bidding on average $64 for this job

gaffapi

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

$80 USD in 1 day
(110 Reviews)
6.6
netcoder

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

$55 USD in 5 days
(56 Reviews)
5.5
rajanlengde

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

$30 USD in 0 days
(29 Reviews)
5.2
ddumitrascu

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

$75 USD in 2 days
(53 Reviews)
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 days
(1 Review)
4.4
SOFTWAREALLIANCE

Hi Send me message

$50 USD in 100 days
(1 Review)
4.0
ocherk

Hi I can do it. Regards.

$100 USD in 3 days
(3 Reviews)
3.6
sureshmalankar

Please see pm for details.

$55 USD in 2 days
(4 Reviews)
3.1
kidunix

Check feedback and PMB.

$80 USD in 0 days
(3 Reviews)
3.0
softwareprabhu

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

$100 USD in 7 days
(4 Reviews)
1.9
ugumugu

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

$60 USD in 1 day
(1 Review)
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 days
(2 Reviews)
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 More

$60 USD in 2 days
(1 Review)
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 days
(1 Review)
0.8
bissolutions

Please check PMB for Details. Regards, BIS Solutions

$75 USD in 2 days
(0 Reviews)
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 days
(0 Reviews)
0.0
vladag

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

$30 USD in 1 day
(0 Reviews)
0.0
UTStudios

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

$50 USD in 2 days
(0 Reviews)
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 More

$100 USD in 7 days
(0 Reviews)
0.0
indriyum

Hi I can do it. Regards.

$30 USD in 5 days
(0 Reviews)
0.0