F
fmunoz01
Guest
Does anyone know how to or a simpler way of having a query, in which it's calculated field expressions (formulas) are obtained from a table, instead of the actual query?
Example:
Query
================================
Query Field Name = "SQ FT of Unit"
Query Field Value = Dlookup("[Formula]","Formulas","[FormulaName]='SQ FT of Unit'")
Formula Table
================================
Formula Name = "SQ FT of Unit"
Formula = [Length]*[With]/144
RESULT:
===============================
When you run the query it should calculate to a number value, but instead when you run the query it shows the expression formula([Length]*[With]/144)as text instead.
What am I doing wrong or what can I do to calculate the formula it looks up in another table as an expression, instead of just showing the formula as text when you run the query? Can anyone help?
Example:
Query
================================
Query Field Name = "SQ FT of Unit"
Query Field Value = Dlookup("[Formula]","Formulas","[FormulaName]='SQ FT of Unit'")
Formula Table
================================
Formula Name = "SQ FT of Unit"
Formula = [Length]*[With]/144
RESULT:
===============================
When you run the query it should calculate to a number value, but instead when you run the query it shows the expression formula([Length]*[With]/144)as text instead.
What am I doing wrong or what can I do to calculate the formula it looks up in another table as an expression, instead of just showing the formula as text when you run the query? Can anyone help?