Report Lookup Problem

[JD McLeod]

I am attempting to perform a lookup on a report and having some problems.
First some background. I have a table called Assessment_Grade with 2 columns
in it – one for assessment_rating and one for assessment_grade. For example
the rating is high and the grade is 3, or moderate and 2 or low and 1. The
reason I have a number is that it is used in calculations. This is the only
data in this table. I use this table in lookups on several forms to display
the grade high, low etc. for the user to choose from, but actually store the
numerical value in the table. One such table where a form is used is the
risk_assessment table. Data in this table is populated by users completing a
form and selecting the risk rating. The form then stores the numerical value
in the table. I now want to run a report on the risk_assessment table, but I
get the numerical value on my report when I actually want the rating, i.e.
high, low, etc. I tried to use lookup formula on the report, but could not
get it to work. Can anyone tell me where I am going wrong? Thanks.

 

[Marshall Barton]

I am attempting to perform a lookup on a report and having some problems.
First some background. I have a table called Assessment_Grade with 2 columns
in it – one for assessment_rating and one for assessment_grade. For example
the rating is high and the grade is 3, or moderate and 2 or low and 1. The
reason I have a number is that it is used in calculations. This is the only
data in this table. I use this table in lookups on several forms to display
the grade high, low etc. for the user to choose from, but actually store the
numerical value in the table. One such table where a form is used is the
risk_assessment table. Data in this table is populated by users completing a
form and selecting the risk rating. The form then stores the numerical value
in the table. I now want to run a report on the risk_assessment table, but I
get the numerical value on my report when I actually want the rating, i.e.
high, low, etc. I tried to use lookup formula on the report, but could not
get it to work. Can anyone tell me where I am going wrong? Thanks.

Since you didn't post the lookup you tried, I can't hazard a
guess about why it didn;t work.

The more common approach is to set the report's record
source to a query that includes both tables. This way you
can include the numeric value from the original table and
the text for that value from the lookup table. The text box
for the rating can then be bound to the field from the
lookup table.