Hello,
I want to have a table describing the various field names that are used in a database. The data to be held in some of the fields are raw data but other fields will be calculations based on other fields. In my table "tblMyFieldNames" I would want to have two columns:
"FieldName" and "CalculationFormula".
The Calculation field would be blank for those fields that hold raw data but would contain a formula for those fields that require a calculation explaining how the field value is calculated. The calculation would not take place in the table, only be a store so that users can see how a field value is calculated. However, is there a way that such a table can be included in a query so that the query performs the calculation in the field CalculationFormula if it is not blank? This would save having to update the formulas in both the tables and the queries.
Thanks for any help/advice.
David
I want to have a table describing the various field names that are used in a database. The data to be held in some of the fields are raw data but other fields will be calculations based on other fields. In my table "tblMyFieldNames" I would want to have two columns:
"FieldName" and "CalculationFormula".
The Calculation field would be blank for those fields that hold raw data but would contain a formula for those fields that require a calculation explaining how the field value is calculated. The calculation would not take place in the table, only be a store so that users can see how a field value is calculated. However, is there a way that such a table can be included in a query so that the query performs the calculation in the field CalculationFormula if it is not blank? This would save having to update the formulas in both the tables and the queries.
Thanks for any help/advice.
David