Hi Cathy:
Here is an expression I used in the report for a field. The idea here is to evaluate whether the SortKey is for Consultations. If so, then print both the description and the Date Referred (Date1), else, just print the Descr field.
iif(TmpData.SortKey = "6", TmpData.Descr+" "+TmpData.Date1, TmpData.Descr)
However, I get a "Operator/operand type mismatch". Wondering if the concats of the Descr and the Date1 fields is causing the problem. If so, how do I get the Date Referred also to print for consults?
Thanks Cathy.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons