Update Query Using 2 Tables & Conditions (1 Viewer)

Hi

I am working with 2 tables: "DEPART_NAMES_AS SUBMITTED" and "DEPART_NAMES_REQUIRED." Each table has a field for DEPART_NAME and LINE_NUMBER. I would like to update the DEPART_NAME_SUBMITTED table using the names in the DEPART_NAMES_REQUIRED table only if the line number falls between the [LOW] [HIGH] range. I have tried many queries including the following:

UPDATE DEPT_NAMES_SUBMITTED INNER JOIN DEPT_NAMES_REQUIRED ON (DEPT_NAMES_SUBMITTED.LINE_NUMBER = DEPT_NAMES_REQUIRED.HIGH) AND (DEPT_NAMES_SUBMITTED.LINE_NUMBER = DEPT_NAMES_REQUIRED.LOW) SET DEPT_NAMES_SUBMITTED.DEPART_NAME = [DEPT_NAMES_REQUIRED].[DEPART_NAME]
WHERE (((DEPT_NAMES_REQUIRED.LINE_NUMBER) Between [low] And [high]));

Thank you in advance for taking the time to read and respond to this question.

Al

what is [LOW] and [HIGH] is it a textbox or combobox control on your form?