You can use what's called a "Non Equi Join" to do this. Try
UPDATE [second table]
SET [the second table field] = [lookup table].[FreqSubband]
FROM [second table] INNER JOIN [lookup table]
ON [second table].[NewTxFrequency] >= [lookup table].[FreqLo]
AND [second table].[NewTxFrequency] <= [lookup table].[FreqHi]
This might not be an updateable query; if that's the case you may need a
subquery instead:
UPDATE [second table]
SET [the second table field]
SELECT [FreqSubband] FROM [lookup table]
WHERE [second table].[NewTxFrequency] >= [lookup table].[FreqLo]
AND [second table].[NewTxFrequency] <= [lookup table].[FreqHi])
However... what if there are two or more qualifying NewTxFrequency values? Or
none?
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also
http://www.utteraccess.com