How to use eval() with dlookup() ?

[Maximnl]

In a query I use the following expresion:

AREA: Eval(DLookUp("[VALUE]";"VAR";"[NAME]='AREA' "))

The subexpression
DLookUp("[VALUE]";"VAR";"[NAME]='AREA' ") results in string

[BREDE] * [LENGTE] .

In the current query table, [brede]=5 and [lengte]=4

So eval() should return 20.

Nevertheless Eval does not evaluate Dlookup result and returns [BREDE] * [LENGTE]. How to get 20?

Is there any way to execute an expression defined elsewhere at the runtime using Dlookup?


Maxim

http://www.4suc6.com