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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab queries, <> and null values 3
extract 3 numbers from a string 0
What Kind Of Query Can I use? 6
Access Running Balance in Access 1
Query showing duplicate values 2
Determining EVERY month between 2 given dates 13
Converted from LINUX time ok, but having issues with the between date. 4
Supressing a #VALUE! error returned? 3

Back
Top