Show a report from another table in record, based on a range of numbers

I'm wondering if there's a way to have a report from another table show in a record, based on a range of numbers falling within a range of 2 other numbers.  

For example:  I have table A with 2 fields that are numbers.  Let's say they are called Low# and High#.   In table B, I have the same fields as well.  Is there a way I can have a report in table A's form, that will show me any records in table B where the 2 numbers fall within the range of the 2 numbers?

Say table A record #100 is Low# 500 and High# 1000.  Records that would show from table B would be ​Low# 600 and High# 800.  Or even Low# 500 and High# 1000.  But Low# 499 and High# 800 would not show, since the low # falls out of range.  

Is there a way to do something like this?

Thanks!​

------------------------------
Dana Hauser
------------------------------