Re: Updating species names for existing records
Hi
I am very grateful to Sarah Shaw, Steve Wilkinson and possibly others for sorting out problems with my database and getting me past the point of having an incomplete dictionary update. I am very pleased to have what seems like a fully functioning R6 with the BOU 2006 checklist working for all new imports.
This is very good, but raises another relatively minor issue, but one that I would prefer to overcome, if possible. When I am reporting, I see that all the 'old' records (ie pre-R6) have the 'old' species names. Hence, in reports the same species may be reported in two different sections - if sorted alphabetically by common name. I have too many 'old' records to update the species name in each record manually. Does anyone know of a method of updating old common names with the new ones? In theory, it needs a macro to check the common species name in each record, compare that with a look-up table of species with changed names, and change the name if a new one is listed and go through all the records. That sentence was fairly easy to say, but is there a macro available to do the job? I'm not sure that my programming skills are up to implementing what I need.
Any ideas? Thanks in anticipation of a response!
Cheers, Ian