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.
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!