I have an array of alias variables each value in the array is a column name
in a table. I need to do a proportion overlap query and also include the
columns in that array which the user has selected from a popup control of
the column names. How do I do it? For example:
if aliasColumnList represented these values which the user would have
randomly selected:
aliasColumnList(1) = mytable.col1
aliasColumnList(2) = mytable.col6
aliasColumnList(3) = mytable.col15
How do I get the following to work?
Select aliasColumnList,
Sum(ProportionOverlap(BaseTableobj,SubTableobj)*100),
Sum(ProportionOverlap(SubTableobj,BaseTableobj)*100)
>From BaseTable,SubTable
Where BaseTableobj Intersects SubTableobj
Into ResultsTable
Any help would be greatly appreciated
