Query Design Help

[Kuzac]

I am trying to do a filter query for a database containing personel
information. I have a master roster of everyone living in the area, each week
the operations of each section send in a report of who is living where and
all there information.

I want to run a query that will match up to my master list and tell me in
the end those who moved to another room, moved out or moved in. I cannot seem
to get it right and when it comes out it shows me my master roster again.

 

[John W. Vinson]

I am trying to do a filter query for a database containing personel
information. I have a master roster of everyone living in the area, each week
the operations of each section send in a report of who is living where and
all there information.

I want to run a query that will match up to my master list and tell me in
the end those who moved to another room, moved out or moved in. I cannot seem
to get it right and when it comes out it shows me my master roster again.

Please post a description of your tables - tablenames, relationships, and the
significance of each table. We can't see them, and your post doesn't give
enough information to let anyone construct a query.

 

[Kuzac]

Please post a description of your tables - tablenames, relationships, and the
significance of each table. We can't see them, and your post doesn't give
enough information to let anyone construct a query.

Room - Last name - firstname - rank - last 4 SSN - unit
126A - johnson - david - SFC - **** - 449th
143B - hutchins - kate - 1SG - **** - 329th
327C - weldon - chris - MAJ - **** - 101st

both rosters have the same colomns, the rows are only related by the room #.
I want to do a query that will weed out all those that have the same maching
information and show me what does not match the master roster.

After running this query, I want to be able to update the master roster with
the new data so that I don't have to copy and past into it. I think I know
how to do that by exporting it out, but I want to make sure.

 

[Kuzac]

Table A: Master POD Roster - I control this listing
Table B: 47th FSB Roster - listing each unit operations sends me every week

Room - Last name - firstname - rank - last 4 SSN - unit
126A - johnson - david - SFC - **** - 449th
126A - steinkamp - josh - SSG - **** - 449th
143B - hutchins - kate - 1SG - **** - 329th
143B - castro - latasha - CPT - **** - 872nd
327C - weldon - chris - MAJ - **** - 101st
467C - stillwater - brian - SPC **** - 47th

Both rosters have the same colomns, the rows are only related by the room #.
All of the rooms contain 1-2 people, I hope that this will not cause a problem when 1 name is above the other, but on the master roster it is in the opposite order. I want to do a query that will weed out all those that have the same maching
information and show me what does not match the master roster.

After running this query, I want to be able to update the master roster with
the new data so that I don't have to copy and past into it. I think I know
how to do that by exporting it out, but I want to make sure.

I made a few changes since i forgot 1 huge aspect on multiple people in 1
room and added my table names to the top.