Unmatched Query

[terryzs]

Hi!

Please find attached database.
I have created a query to find unmatched data.
Where I'm doing wrong?

S_log = 301 & T_log = 292 record.

Unmatched should be 9 record

I'm getting 301.?????

Can any one help me in this.

Regards,
Terry.

 

[Ziggy1]

Your Data types are out of wack. I exported your data and imported it back in and corrected the formats and it worked. even though they looked OK on yours the "formats" were different between tables. just changing them to match did not seem to work.

 

[terryzs]

Thanks.

Hi!

Thanks for giving your time and help.

Terry.

 

[Ziggy1]

no probs

Ziggy