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: