 | |
newbie question, conditional record in a report
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
newbie question, conditional record in a report -
01-21-2008
, 04:21 PM
#2
| |||
| |||
|
|
I have built the table that has a field with records 1, 3, 5.. How can I show them differently in the report? like 1= customer, 3 =distributor, 5 = owner .. I'm not sure I understand your question. Is it to show a verbose |
box. Set the combobox row source to Value (under data tab in the
combo's property sheet) and enter something like
1;"Customer";3;"Distributor";5;"Owner"
and set the column count to 2 and bound column to 1 (your numberic values).
Happy Hawaii
http://www.youtube.com/watch?v=SXDzP9YMBCs
#3
| |||
| |||
|
|
shichen1... (AT) yahoo (DOT) com wrote: I have built the table that has a field with records 1, 3, 5.. *How can I show them differently in the report? *like 1= customer, 3 =distributor, 5 = owner .. I'm not sure I understand your question. *Is it to show a verbose description of the code? *It so, you can change the text box to a combo box. *Set the combobox row source to Value (under data tab in the combo's property sheet) and enter something like * * * * 1;"Customer";3;"Distributor";5;"Owner" and set the column count to 2 and bound column to 1 (your numberic values).. Happy Hawaiihttp://www.youtube.com/watch?v=SXDzP9YMBCs |
#4
| |||
| |||
|
|
On Jan 21, 4:41 pm, Salad <o... (AT) vinegar (DOT) com> wrote: shichen1... (AT) yahoo (DOT) com wrote: I have built the table that has a field with records 1, 3, 5.. How can I show them differently in the report? like 1= customer, 3 =distributor, 5 = owner .. I'm not sure I understand your question. Is it to show a verbose description of the code? It so, you can change the text box to a combo box. Set the combobox row source to Value (under data tab in the combo's property sheet) and enter something like 1;"Customer";3;"Distributor";5;"Owner" and set the column count to 2 and bound column to 1 (your numberic values). Happy Hawaiihttp://www.youtube.com/watch?v=SXDzP9YMBCs Thanks.... |
and CodeDescription. Then in your report recordsource (in the Data tab
for the report) add this table and link it to the field in the main
table (that has the number). Then drag the description field to your
report. Your report will look nicer than a combo box. You can do this
from your dataentry form as well.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.