I have a table (tblUSBSummary)with over 20,000 records that I need to update with info based on another table (tblIPRange).
tblUSBSummary has a field called IPAddress that contains data and a field called Unit that needs to be updated.
tblIPRange has a field called IPFrom and a field called IPTo and a field called Unit; all of which contain data.
BTW, all fields are text fields.
How do I update tblUSBSummary to show the unit info contained in tblIPRange based on the IPAddress being within the IPTo and IPFrom.
Thanks in advance. :shock: