I'm wondering if you're able access the row heading names in a crosstab table.
We have a "freeform" Products table that contains entries ProductNumber, ProductProperty, ProductPropertyValue as follows:
table products
** ProductNumber
>>> 1,2,3,4, ...
** ProductProperty
>>> "property1", "property2", ... (max 100) like height, width
** ProductPropertyValue
>>> value1, value2, ...
I would like to be able to access the value ProductProperty:
ProductPropertyValue of "property1", so you could use <property1> as a Dimension or Measure. MS-Access offers this functionality (crosstab Row and Column heading).
We have a "freeform" Products table that contains entries ProductNumber, ProductProperty, ProductPropertyValue as follows:
table products
** ProductNumber
>>> 1,2,3,4, ...
** ProductProperty
>>> "property1", "property2", ... (max 100) like height, width
** ProductPropertyValue
>>> value1, value2, ...
I would like to be able to access the value ProductProperty:
ProductPropertyValue of "property1", so you could use <property1> as a Dimension or Measure. MS-Access offers this functionality (crosstab Row and Column heading).