I am working in MS Access 2003. I have 2 Tables both with data. I need the data merged primarily the 'Name', DOB, Sex, & ID fields to make 1 patient table. I also need to you to keep the query apart of the database so that I can perform the query again on another table that I have yet to receive but is exactly the same.
I am so frustrated because I know this is simple I just can't get the logic to do it clear in my head, I'm stomped.
What version of access?
How many records in each table?
2011 & 23171 (but there are many duplicates)
Many many fields?
Only 5 that I actually need to be merged.
33 freelancers are bidding on average $51 for this job
I am a professional in the field of technology. I have been working in this field for more than Five years. I assure you that I would be able to render better services to you.
I can show you step by step in front of your PC remotely. 1st day: show you step by step in front of your PC remotely. 2nd day: provide any follow up if required. Victor