fail to query records that don't exist in another table

[dai_lo]

Hi,

In the Query11, i am comparing two tables' Prod_Str columns and return the Prod_Str record which doesn't exist in tbl_Reconcile_Loans_Breakage_Loans

the query11 doesn't do the job as i expect.

could you tell me what the problem is..

thanks

 

[pbaldy]

Have you tried the unmatched query wizard?

 

[khawar]

Check Query11Modified

 

[dai_lo]

Have you tried the unmatched query wizard?

it works.. thanks