Hi all - I run a wildlife rehabilitation nonpropfit and I'm reasonable computer savvy but barely know any Access at all. I inherited an Access database of all of our 10,000+ animal intakes when I arrived, and I just realized that volunteers have been making additions/changes in two different versions of that database for the last six months.
It seems like the records fall into three categories:
- The large majority of records should be identical between the two, so obviously all of those should be in the "final" version.
- There probably 400 or so new records added to the two databases, and none that should have been deleted. So any record that is in one and not the other probably ought to make it into the final version.
- There are some number, maybe 100 or so, of records that exist in both versions but would have been edited (like when an animal that already had a record for intake got released) in one. These are a little trickier, but probably the more "up to date" version that should be included would be the one that has a "disposition date" included. Maybe that could be used to identify the "good" record to include.
How can I tackle this? Is there some utility or function that could just do it "automatically"? If not, what's the best alternative? I'll do it "manually" if I have to, but I don't even really know how to do that. Just running a "comparison" between the two to identify which records fall into which category above would help, but I don't know how.
Thank you so much for any help anyone can provide. It means a great to deal to us and our wild patients!
It seems like the records fall into three categories:
- The large majority of records should be identical between the two, so obviously all of those should be in the "final" version.
- There probably 400 or so new records added to the two databases, and none that should have been deleted. So any record that is in one and not the other probably ought to make it into the final version.
- There are some number, maybe 100 or so, of records that exist in both versions but would have been edited (like when an animal that already had a record for intake got released) in one. These are a little trickier, but probably the more "up to date" version that should be included would be the one that has a "disposition date" included. Maybe that could be used to identify the "good" record to include.
How can I tackle this? Is there some utility or function that could just do it "automatically"? If not, what's the best alternative? I'll do it "manually" if I have to, but I don't even really know how to do that. Just running a "comparison" between the two to identify which records fall into which category above would help, but I don't know how.
Thank you so much for any help anyone can provide. It means a great to deal to us and our wild patients!
