Hey everyone,
I have an issue I have been working on for a day now and I cant seem to crack it.
I am trying to use wildcards to compare two strings of numbers.
One of the strings may have a few leading numbers.
Example:
Table 1: 92123456789
Table 2: 123456789
Sample code I'm using:
UPDATE [Table 1] LEFT JOIN [Table 2] ON [Table 1].[Tracking#] = [Table 2].[Tracking Number]
SET [Table 1].Description = "Shipment failed to reconcile"
WHERE ((([Table 1].[Tracking#]) Not In ([Table 2]![Tracking Number (Transaction)])));
This code works if they are identical, but it needs to search within a string.
Thanks in advance for any help.
I have an issue I have been working on for a day now and I cant seem to crack it.
I am trying to use wildcards to compare two strings of numbers.
One of the strings may have a few leading numbers.
Example:
Table 1: 92123456789
Table 2: 123456789
Sample code I'm using:
UPDATE [Table 1] LEFT JOIN [Table 2] ON [Table 1].[Tracking#] = [Table 2].[Tracking Number]
SET [Table 1].Description = "Shipment failed to reconcile"
WHERE ((([Table 1].[Tracking#]) Not In ([Table 2]![Tracking Number (Transaction)])));
This code works if they are identical, but it needs to search within a string.
Thanks in advance for any help.