I am trying to write a report, i have a if then and select syntax.
Does anybody know the correct code for the tmcdln.crtfid table/column
I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column.
using y, yes, Y, Yes, YES, "Y", 1, none of these are recognized. Any help will be appreciated.