<div>
Similarly to @crystal, in SQL:<br />

<pre><code id="code-20-42338382-1">SELECT 
	foo
	, bar
	, other
	, fields
	, [SortOrder] = CASE [Risk] WHEN 'High' THEN 1 WHEN 'Medium' THEN 2 ELSE 3 END
FROM YourTable</code></pre>
</div>


Similarly to @crystal, in SQL:


SELECT 
	foo
	, bar
	, other
	, fields
	, [SortOrder] = CASE [Risk] WHEN 'High' THEN 1 WHEN 'Medium' THEN 2 ELSE 3 END
FROM YourTable

<div>
you're welcome ~ happy to help
</div>


<div>
<blockquote>
I agree with Crystal. &nbsp;Defining lookups in a table is generally the best option.
</blockquote>
I think I need to clarify that statement. &nbsp;I was suggesting (as was Crystal) that the RowSource of a combo come from a table or query rather than a value list. &nbsp;I was by no means advocating for table level lookups which are an abomination.
</div>


> I agree with Crystal.  Defining lookups in a table is generally the best option.

I think I need to clarify that statement.  I was suggesting (as was Crystal) that the RowSource of a combo come from a table or query rather than a value list.  I was by no means advocating for table level lookups which are an abomination.

<div>
<div class="content wysiwyg-content">
I have a table that contains a field &quot;Risk&quot; The values in this are either &quot;LOW&quot;, &quot;MEDIUM&quot; or &quot;HIGH&quot;.<br />
I need to report on this but have HIGH at the top of the report, then MEDIUM etc.<br />
<br />
I think I need to add a field in my query that can assign a numeric value dependent on the contents of the Risk field.<br />
<br />
Thanks in advance for any help
</div>
</div>


I have a table that contains a field "Risk" The values in this are either "LOW", "MEDIUM" or "HIGH".
I need to report on this but have HIGH at the top of the report, then MEDIUM etc.

I think I need to add a field in my query that can assign a numeric value dependent on the contents of the Risk field.

Thanks in advance for any help

Order a Report based on Text values

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.