Report writing

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. 

Parents Reply Children
No Data