How do I change data type from string (Y/N) to number format so that I can perform some calculations?
Assuming there are only two possible values, Y or N:
IIF([StringField]='Y',1,0)
will convert Y to 1 and N to 0.
Retrieving data ...