>Hi All,
>just something interesting I need to do... I have use a little SQL code to print a report. if I want to print a praticular value in relation to a field. For example, .T. = Male, .F. = Female, how can that be done?IIF(myfiled, "Male ", "Female")
>Also, how can I print in relation to a string. For Example, I want to print a initial based on a standard record set, I want to print A for Action, B for wait, C for Time out, D for complete, How can I print this?Create lookup table with two fields, FullDesc, ShortDesc and in your select include ShortDesc in the filed list and join tables on FullDesc.
--sb--