I have a data table that contains information to create 2 dot density maps, some to be plotted against layer A and some against layer B.
I would like to specify an addional part of the where clause in the add column statement so that the data table is kind of 'split' into two.
e.g. Add Column "LayerA" (CountOfDataTable Integer)From DataTable Set To Count(*) Where COL1 = COL3 AND DataTable.LayerCode = 'A' Dynamic
 
I have tried similar to above, but with no success, can anyone suggest a way that I could use one datatable to be the source of two different maps ?
 
Cheers,
Scott..

Reply via email to