How do I compare two tables, then add and delete based on one?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2000, how can I compare two tables for differences and then
print our the changes?
Trying to update physcian records for volunteer work I'm doing at a hospital.
Thanks
 
Karl, thanks. Could you give me more details on what you said? I will load
both tables then what? I am not sure if that is posting. How do I get into
the compare mode to define the fields I want compared.
Thanks for your patience.
"lil"
 
By "post" I mean for you to tell us your table structure - like this --
TblDoctor--
DocID - autonumber - primary key
LName - text
FName - text
etc - as approproate

Patient --
PatientID - autonumber - primary key
LName - text
FName - text
Sex - interger - 0-2 - for option group 0 - unknown 1 - male 2 - female
BirthDate - datetime field
etc - as appropriate

Visit --
VisitID - autonumber - primary key
PatientID - number - interger -forigen key
DocID - number - interger -forigen key
InDate - datetime
OutDate - datetime
BP1 - number - interger
BP2 - number - interger
Temp - number - interger
Remarks - memo
etc - as appropriate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two tables 6
Import File Information 0
Comparing table data and adding differential information 1
Importing data based on drop down box selection?? 3
How do i compare...? 3
Add .csv File Name When Importing Multiple Files Into a Table 0
iterating and comparing rows 2
Compare 2 tables and delete from one of them 2

Back
Top