Find unmatched data from 2 different fields in same record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Table data: you can see that there are differences after the data is broken
down

Scan steel receiving Date Kanban card
P063141049 682875 4480 11/28/2006 063141049 101
P063141049 682875 4480 11/28/2006 063141049 101
P063141049 682875 4480 11/28/2006 063141049 101
P063141049 682875 4480 11/28/2006 063141058 101
P063141049 682875 4480 11/27/2006 063141049 101
P063181041 1234567 5111 11/28/2006 063182136 101
P063181041 1234567 5111 11/28/2006 063181041 101
P063181041 1234567 5111 11/28/2006 063181041 101
P063181041 1234567 5111 11/28/2006 063181041 101
P063181041 1234567 5111 11/28/2006 063182137 101
P063181041 1234567 5111 11/28/2006 063181049 101
P063181041 1234567 5111 11/28/2006 063151041 101
P063181041 1234567 5111 11/28/2006 063181052 101
P063181052 6828751 380 11/28/2006 063181052 101
P063181052 6828751 380 11/28/2006 063181049 101
P063181052 6828751 380 11/28/2006 063181041 101

Data broken down with differences, but only 6 matches where there should be 8:
Item Card Part
063141058 101 063141049
063182136 101 063181041
063182137 101 063181041
063181049 101 063181041
063151041 101 063181041
063181049 101 063181052
 
Terry,

I see the data set and the result set, but I don't know the question.

What have you tried? What do you want to do with the result set?

Are you using VBA or SQL?


I created a table and made a query. This query returns 8 rows that have
differences:


SELECT YourTable.ScanSteelReceiving, YourTable.KanbanCard,
Mid([ScanSteelReceiving],2,9) AS Item, YourTable.KanbanCard AS Card
FROM YourTable
WHERE (((Mid([ScanSteelReceiving],2,9))<>Left([KanbanCard],9)));


Change "YourTable" to the name of your table. Also, I removed the spaces in
the field names. You should also change the field name "DATE" to something
else because "DATE" is a reserved name in Access


HTH
 
Back
Top