Comparing values from table1 and table2

[kaarell]

Hello everyone! I've found much use of this forum recently as I am working on a database concerning my work.

I'm not a newbie working with access but this problem seems confusing at the beginning.

I've got 2 tables
1) Information about produced details. Article, Mass etc.
2) Mass constants
Mass min. Mass max. Constant

What I need, is to build a query that compares the mass of the detail with the range mass min. and mass max. and shows the mass constant that the detail belongs to.

Has anyone tried to solve this kind of issue before?

Greets from Estonia,
K

 

[grnzbra]

Create a public function that looks at a recordset of the mass constants and selects the record where the InputValue >= [Mass Min] AND InputValue <= [Mass Max]. Then set the function equal to the value of the corresponding constant.

In your query, Constant = YourFunction(Mass)