Lookup or something similar

[ckchappell]

I'm pretty sure I asked this about 6 months ago, but I cannot find my topic nor am I having much luck searching for this. But maybe it wasn't here....

I have 3 separate text values that already exist or will be entered into a table (L, M and H) that I am wanting to place into a report. But I would like them to show up in the report as a dollar value along with some additional text.

Like

L (Low Priorty) = $100
M (Medium Priority) = $175
H (High Priority) = $250

I recall there is some pretty simple

 

[CameronM]

Since you only have 3 values, you could try nested IIF statements as a field in the query for the report, something like:

IIF([FieldName]="L", 100, IIF([FieldName]="M",175,IIF([FieldName]="H",250,0)))

If the list of values could grow, you may want to have a seperate table containing the value pairs, which would be easier to change.