My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Translate numbers to caption on report
|
|
 Jun 13 2008, 01:10 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 142  |
I created a form that has an option group. The option group gives me the data for each option as a 1 or 2. I am building a report and instead of my report pulling the "1" or "2" from the table and displaying this, I would like to translate the 1 to be a phrase and the 2 to be another phrase on the report solely. Can I set some type of IF statement on the record source or anything similar to achieve this.
|
 |
 
|
|
Jun 13 2008, 01:32 PM
Post
#2
|
|
|
UtterAccess Guru Posts: 652 From: Auckland, New Zealand |
Certainly can, and very easy to do in Access.
=IIF([MyField]=1,"Put phrase 1 in here","Put phrase 2 in here") KG |
|
|
|
|
Jun 13 2008, 03:00 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 142 |
Do I need to enter that in the 'control source' property for the textbox that reads to the report.
|
|
|
|
|
Jun 14 2008, 08:27 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 7,232 From: Belgium |
Yes, add the above mentioned expression in the control source property of the textbox
HTH Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif) Luc aka Kuifjexx Edited by: kuifjexx on Sat Jun 14 9:28:26 EDT 2008. |
|
|
|
|
Jun 14 2008, 11:34 AM
Post
#5
|
|
|
UtterAccess Addict Posts: 142 |
Got it. Works great. Thanks.
|
|
|
|
|
Jun 14 2008, 04:52 PM
Post
#6
|
|
|
UtterAccess VIP Posts: 7,232 From: Belgium |
Glad to hear the problem is solved (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif) Luc aka Kuifjexx |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 21st May 2013 - 05:22 AM |