Value based on text

[mrichey]

Hi, using Access 2000 and need to create a formula that calculates a value based on the text input. Maybe in a query, or in the table itself? Here's an example:

Area Measurement Phase Value
Network Device Up/Down Deployed 2.5
Network SNMP Alerts Deployed 2.5
Network Performance Data Partially Deployed 1.5
Network VTAM SNA Network Deployed 2.5
Network Configuration Manageme Not Deployed 0.5

Based on whether the phase is deployed or not deployed the value would change (0.5=not deployed, 1.5=partially deployed, 2.5=deployed)

Any help would be great, not a programmer obviously. Thanks!

 

[PHV]

Something like this (SQL code) ?
SELECT Area, Measurement, Phase,
IIf([Phase]='Deployed',2.5,IIf([Phase]='Partially Deployed',1.5,0.5)) As [Value]
FROM ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886