User inputs criteria, which is calculated in a query to produce a base factor.
With this base factor I need to apply a predetermined “Multiplier” from a table which I have created. This multiplier is based on (2) of the previous determined values.
I’ve been trying Dlookup with many different configurations, but just can’t to seem to get it to return a value.
This is my latest try:
Expand|Select|Wrap|Line Numbers
- Multiplier: DLookup ([tbl:ShapeMultiplier]![Multiplier], [tbl:ShapeMultiplier], [que:Main]![Shape] = [tbl:ShapeMultiplier]![Shape] And [que:Main]![Total Sq Footage] = [tbl:ShapeMultiplier]![Square Feet])
que:Main
Any suggestions as to what I might have to change to get this to work????