I gang

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.

Færdigheder: Databehandling, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 54 bedømmelser ) London, United Kingdom

Projekt-ID: #29452

Tildelt til:

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 på 1 dag
(11 bedømmelser)
4.1

27 freelancere byder i gennemsnit $64 for dette job

gaffapi

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

$80 USD på 1 dag
(110 bedømmelser)
6.6
netcoder

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

$55 USD in 5 dage
(56 bedømmelser)
5.5
rajanlengde

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

$30 USD in 0 dage
(29 bedømmelser)
5.2
ddumitrascu

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

$75 USD in 2 dage
(53 bedømmelser)
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 dage
(1 bedømmelse)
4.4
SOFTWAREALLIANCE

Hi Send me message

$50 USD in 100 dage
(1 bedømmelse)
4.0
ocherk

Hi I can do it. Regards.

$100 USD in 3 dage
(3 bedømmelser)
3.6
sureshmalankar

Please see pm for details.

$55 USD in 2 dage
(4 bedømmelser)
3.1
kidunix

Check feedback and PMB.

$80 USD in 0 dage
(3 bedømmelser)
3.0
softwareprabhu

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

$100 USD in 7 dage
(4 bedømmelser)
1.9
ugumugu

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

$60 USD på 1 dag
(1 bedømmelse)
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 dage
(2 bedømmelser)
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 Mere

$60 USD in 2 dage
(1 bedømmelse)
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 dage
(1 bedømmelse)
0.8
bissolutions

Please check PMB for Details. Regards, BIS Solutions

$75 USD in 2 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
0.0
vladag

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

$30 USD på 1 dag
(0 bedømmelser)
0.0
UTStudios

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

$50 USD in 2 dage
(0 bedømmelser)
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 Mere

$100 USD in 7 dage
(0 bedømmelser)
0.0
indriyum

Hi I can do it. Regards.

$30 USD in 5 dage
(0 bedømmelser)
0.0