Lookup form value between limits. 1

[reg999]

I have a table of inventoried parts. The parts have different markup percentages based on the cost of the part.

In a form to update inventory cost and markup, I am trying to add a control that will display (for user reference) my standard markup percentage based on cost. I have added a table for my standard markup percentages. "MarkupTbl" as follows.

Lower Upper Markup
LowerVal UpperVal MarkupVal
LowerVal2 UpperVal2 MarkupVal2
etc.

Based on the unit cost on my form [Cost]/[UnitsPer] I need to lookup the corresponding 'Markup' where the unit cost falls between upper and lower values and display it in the new control.

It seemed that this would be easy, but I am having trouble. Thank you for any assistance.

 

[Remou]

Perhaps:

=DLookUp("MarkUp","MarkUpTbl",[UnitCost] & " Between [Lower] And [Upper]")

http://lessthandot.com

 

[reg999]

So simple. I went off in the wrong direction.

My sincere thanks to you, Remou