En cours

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.

Compétences : Traitement de Données, Visual Basic

Voir plus : 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

Concernant l'employeur :
( 54 commentaires ) London, United Kingdom

N° du projet : #29452

Décerné à :

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 en 1 jour
(11 Commentaires)
4.1

27 freelance ont fait une offre moyenne de 64 $ pour ce travail

gaffapi

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

80 $ USD en 1 jour
(110 Commentaires)
6.6
netcoder

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

55 $ USD en 5 jours
(56 Commentaires)
5.5
rajanlengde

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

30 $ USD en 0 jours
(29 Commentaires)
5.2
ddumitrascu

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

75 $ USD en 2 jours
(53 Commentaires)
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 en 2 jours
(1 Commentaire)
4.4
SOFTWAREALLIANCE

Hi Send me message

50 $ USD en 100 jours
(1 Commentaire)
4.0
ocherk

Hi I can do it. Regards.

100 $ USD en 3 jours
(3 Commentaires)
3.6
sureshmalankar

Please see pm for details.

55 $ USD en 2 jours
(4 Commentaires)
3.1
kidunix

Check feedback and PMB.

80 $ USD en 0 jours
(3 Commentaires)
3.0
softwareprabhu

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

100 $ USD en 7 jours
(4 Commentaires)
1.9
ugumugu

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

60 $ USD en 1 jour
(1 Commentaire)
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 en 21 jours
(2 Commentaires)
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 Plus

60 $ USD en 2 jours
(1 Commentaire)
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 en 2 jours
(1 Commentaire)
0.8
bissolutions

Please check PMB for Details. Regards, BIS Solutions

75 $ USD en 2 jours
(0 Commentaires)
0.0
seejee

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

50 $ USD en 5 jours
(0 Commentaires)
0.0
vladag

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

30 $ USD en 1 jour
(0 Commentaires)
0.0
UTStudios

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

50 $ USD en 2 jours
(0 Commentaires)
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 Plus

100 $ USD en 7 jours
(0 Commentaires)
0.0
indriyum

Hi I can do it. Regards.

30 $ USD en 5 jours
(0 Commentaires)
0.0