Hi,
I have 2 tables in Access, "Table 1" and "Table 2". Boths tables have 2 fields, "SysID" and "Flex02".
How can I create a function similar to Excel where in "Table 1" I can lookup "SysID" from "Table 1" against "SysID" from "Table 2" and return the value of "Flex02" from "Table 2" into a new field in "Table 1".
Bookmarks