Access data manipulation
Orçamento $30-100 USD
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!
Concedido a:
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.
27 freelancers estão ofertando em média $64 para esse trabalho
I can write a program on delphi which will do this. Support and further updates will follow.
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
Which to choose? Select us because you will benefit from the fact we want to earn back our lost star.
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
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
hi get you project with bugs free, sir i'll give you project within committed date.. soon as posible