Code:
Table 1:
ID Location TechID Etc...
1 FJC13D1 10331 Other stuff/columns
2 etc...
Table 2:
ID Location TechID Other different etc....
1 FJC?? 10 33 1 Other stuff/columns
2 FJ 11 32 3 Other stuff/columns
3 31 32 6 Other stuff/columns
Table 1 contains complete entries, table 2 contains some entries, but mostly partial or missing entries, so I will need to be able to handle a null and keep going for either the id or location columns(in either table). And I need it to take the "techid" from table 2 and pull the entry into a variable, remove the spaces from the variable, then search the other table for a corresponding entry, then entering the information into the correct spot on table 2.
I know parts of what I need to know concerning update queries and such, but with queries I have never had it interpret the data before it does what it does with other tables and I don't know how to make what I need. I know how to do this with an excel macro, but I need to be able to do it in Access.