Access Report Code

[Tim Eagle]

I have a report. On the report are fields brought in from a query which is
pulling the fields from a table, common knowledge, on the report I want to
know the code to create a dollar amount for grades. For example, A shows up
on the report and for each A, in another column, I want a dollar amount
assigned, for example A=$7.00, B=$5.00, etc, etc. How can I accomplish this?
Thanks.

Tim Eagle

 

[Guest]

Build a reference table with Grade and Dollar fields.
Use this query --
SELECT Data.Question, Data.GRADE, Grades.Dollar
FROM Data LEFT JOIN Grades ON Data.GRADE = Grades.Grade;