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
[login to view URL];q=company+name+type+of+business+city&meta=
Please only bid if you can do this within the time that you state. Thanks.
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 products in Kyrgyz Telecom for 2 years). I can complete Access Data Manipulation project for $60 in 2 days. Commit your project to real professional and save your money and time. Regards Vladimir Kuznetsov.