I think I should know this...
I'm trying to find duplicates records on two table and blanks. I've linked two tables and it shows all the records that are in both tables. But I can't get it to include all the records that are empty in the ecp effectivity column.
I'm trying to find duplicates records on two table and blanks. I've linked two tables and it shows all the records that are in both tables. But I can't get it to include all the records that are empty in the ecp effectivity column.
Code:
SELECT REV1Val_WP_Tracking.*
FROM REV1Val_WP_Tracking INNER JOIN TM_tbl ON REV1Val_WP_Tracking.[ECP Effectivity] = TM_tbl.TrackingID
WHERE (((REV1Val_WP_Tracking.[ECP Effectivity])=[TM_tbl].[TrackingID]) OR REV1Val_WP_Tracking.[ECP Effectivity] =null);