Hi Cetin

>Oh you can check what's different comparing its members.

Yes, I guess so. thanks.

>What I mean is for it to work both tables should not only have identical structure but 'same' records with same 'recno'. What if recno 1 in table 1 is duplicated in table 2 recno 5? Hope I could explain it:)

Yes, but the tough and simple thing is that the records are from the same table, so the structure is definately the same just I want the contents to be compared, say for eg. between recno 5 and 15. As 15 is a record which is working well in a report and rec. no. 5 is not showing properly in the same report, but it should have, so if I can get the differences I will able to pinpont the problem area, data or code.