newbie question, conditional record in a report

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 ..

Re: newbie question, conditional record in a report

shichen1979@yahoo.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 Hawaii
http://www.youtube.com/watch?v=SXDzP9YMBCs

Re: newbie question, conditional record in a report

On Jan 21, 4:41=A0pm, Salad wrote:
> shichen1...@yahoo.com wrote:
> > I have built the table that has a field with records 1, 3, 5.. =A0How
> > can I show them differently in the report? =A0like 1=3D customer, 3
> > =3Ddistributor, 5 =3D owner ..
>
> I'm not sure I understand your question. =A0Is it to show a verbose
> description of the code? =A0It so, you can change the text box to a combo
> box. =A0Set the combobox row source to Value (under data tab in the
> combo's property sheet) and enter something like
> =A0 =A0 =A0 =A0 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=3DSXDzP9YMBCs

Thanks....

Re: newbie question, conditional record in a report

shichen1979@yahoo.com wrote:
> On Jan 21, 4:41 pm, Salad wrote:
>
>>shichen1...@yahoo.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....

You might also want to consider a lookup table. Create 2 fields; Code
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.