I am doing this:
selectcount(col1) from chgnotce

It is not working. could you please tell me what is the right way to use the col1 which is a variable in it i am getting the field name.

*******************Start***********************
for n = 1 to thisform.list1.listcount
col1 = thisform.list1.listitem(n, 1)
**col2 = thisform.list1.listitem(n,2)
select count(col1) ;
from chgnotce where not empty col1 and;
DELETED() = .F. into cursor lcSource
endfor
***********************************************

Thank you.