Best query type for returning value based on a scale

[DB2010MN26]

I'm trying to determine if its possible to do the following in a single update query. I have two fields, [PEG] and [PEGSCORE]. [PEGSCORE] is the field that will be updated as a result of my query, [PEG] is the field that is used to determine the value entered in [PEGSCORE]. What I want to do is the following:

If PEG<.5, update [PEGSCORE] to 3


If PEG<1, update [PEGSCORE] to 2
If PEG<2, update [PEGSCORE] to 1
all other values return value 0

Is it possible to do this in a single update query or will I have to run 4 seperate ones for each potential outcome?

[RuralGuy]

You should be able to do it with an IIF statement or a UDF.

[June7]

Saving calculated/dependent data can be bad idea. If PEG value were changed, the PEGSCORE could then be incorrect. This PEGSCORE can be calculated whenever needed.

[DB2010MN26]

Understood, but to clarify, I'm appending the source data to a new table prior to performing these calculations.

[June7]

Appending source data to a new table - now I am really confused. Why duplicating records? Doesn't alter my comment about dependent calcs.

[DB2010MN26]

I'm feeding this information into a table in access from an excel file, I'm not pulling the data from an ODBC table or anything, so if PEG changes, I'll be recalcuating/appending the information into the database regardless.

[June7]

Okay, if you must, have you figured out the IIf?

In the UpdateTo row under PEGSCORE:

IIf(PEG<.5,3, IIf(PEG<1,2, IIf(PEG<2,1,0)))

[DB2010MN26]

Okay, if you must, have you figured out the IIf?

In the UpdateTo row under PEGSCORE:

IIf(PEG<.5,3, IIf(PEG<1,2, IIf(PEG<2,1,0)))

That works perfect, thanks!