labeling a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If the data in my query is a numerical value how can I change it to show what
the value represents. For example, if 01 means Customer, how can I get my
report to show Customer instead of the 01 value?
 
If the data in my query is a numerical value how can I change it to show what
the value represents. For example, if 01 means Customer, how can I get my
report to show Customer instead of the 01 value?
Click to expand...

Exp:IIf(FieldA] = 1,"Customer","What do you want if it isn't 1")
 
Back
Top