I really need some help here please so would be grateful if anyone has an idea as to what is going on!
I have 2 tables. One of the tables has 191 records and the other 221 records. The tables contain the same data and I need to know how to run a query to show which records are missing from the 191 table.
To acheive this I have added both tables to my query and then choose the join properties option and asked for the differnace to be displayed. However upon doing this, for some reason we end up with more records!
Does anyone have a clue as to why this would be the case ?
Regards. Pari.
I have 2 tables. One of the tables has 191 records and the other 221 records. The tables contain the same data and I need to know how to run a query to show which records are missing from the 191 table.
To acheive this I have added both tables to my query and then choose the join properties option and asked for the differnace to be displayed. However upon doing this, for some reason we end up with more records!
Does anyone have a clue as to why this would be the case ?
Regards. Pari.