Hi, I have a report which is grouped by Transaction Type, which is a 2 digit field in the G/L file. for example 05 stands for adjustment, 10 stands for invoice, etc. Is there a way that I can have text print out for each group level, explaining what the code means? I have no table to pull the descriptions from.   Thanks in advance for your help!

SWITCH should work, but I never remember the syntax off the top of my head...something like
SWITCH({table.field},
"02", "what a 2 means",
"10", "what a 10 means")

or there is the if then way
if {table.field}="05" then "adjustment"
else if {table.field}="10" then "invoice"
//etc

HTH

Switch is similar to a "Case" statement in programming. Basically, it's like a big if..then..else if..then else if.. type statemtent. If you'll look at what Lockwelle and I both posted, we set it up so that it looks like "pairs" of statements separated by commas. The first part of each pair evaluates to true or false (the "if" part of the statement) and the second is the value you want to return if the first part is true (the "then" part of the statement. The final "True" in what I posted is like a "default" value that defines the result if none of the other statements are true.

-Dell