How does one extract information from value list in a report ?

  • Thread starter Thread starter Angela Yong
  • Start date Start date
A

Angela Yong

I have a large table in Access97 that contains many
fields. One of these fields (here called Factor) has been
defined with row source type = Value list AND row source
is defined as
0;"not applicable";1;"Keep in view" etc...

If I generate a report based on this table, the
information that normally appears will be:
Name Factor
---- ------
xxx 1
yyy 0
zzz 15

But I need the column 2 information connected to the
field "Factor", i.e.:
Name Factor
---- ------
xxx Not relevant
yyy Keep in view
zzz Keep in view

What should I do ?
 
Angela:

You can either change your control on the report to a combo box, just like
on the form and put the value list in the combo's row source or use a Choose
statement with your factor field; aliasing the Factor control's name to
something like "FactorA" (to eliminate circular references), where in the
control source would look like this: = Choose([Factor]+1, "Not
Applicable",Keep In View") etc.; the +1 is used because the Choose statement
always starts at a value of 1, rather than 0 which is the value your factors
start at in the table.
 
Back
Top