Alias or type of lookup question

[jascoGIS]

I know this has probably been covered there but I wasn't really sure how to
phrase this so wasn't very lucky searching for an existing topic. And I'm not
really sure how to ask this to convey what I'm wanting to do.

I have values in a table, Field Name is Priority which contain L, M and H
(for Low Medium and High) which consequently equal $100.00, $175.00 and $250.
00 respectively.

I have a report based on a query which contains among other things, the
Priority field. So, for example, if the query contains "M" I need to indicate
on the report Medium and need to show the corresponding value of $175.00.

---- snippet of report I'd like to see based on the Priority of "M" ---

Priority Level: Medium
Annual Permit Fee: $175.00

---------------------------

I hope what I'm asking is clear enough. I just really have no idea how, but I
know that it should be possible and hopefully fairly easy.

Thank you.

 

[John W. Vinson]

I know this has probably been covered there but I wasn't really sure how to
phrase this so wasn't very lucky searching for an existing topic. And I'm not
really sure how to ask this to convey what I'm wanting to do.

I have values in a table, Field Name is Priority which contain L, M and H
(for Low Medium and High) which consequently equal $100.00, $175.00 and $250.
00 respectively.

I have a report based on a query which contains among other things, the
Priority field. So, for example, if the query contains "M" I need to indicate
on the report Medium and need to show the corresponding value of $175.00.

---- snippet of report I'd like to see based on the Priority of "M" ---

Priority Level: Medium
Annual Permit Fee: $175.00

---------------------------

I hope what I'm asking is clear enough. I just really have no idea how, but I
know that it should be possible and hopefully fairly easy.

Thank you.

There are several ways to do this. This isn't the easiest to implement (though
it's pretty easy!) but is probably the best bet, as it allows you to change
your prices easily in the future.

Create a little three-row table with two fields, Priority and Price. Enter
these values. (If you wish, add a third field Description so that the record
with Priority = "L" contains the string "Low").

Join this table in a query in your report to display the price (and if desired
the description).

 

[jascoGIS via AccessMonster.com]

Pretty much what I needed. Thank you very much. Can't believe I didn't think
of that.