Sorting records in form using numeric fields of each record

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Amir (agamy_at_actcom.co.il)
Date: 01/29/05 

Date: Sat, 29 Jan 2005 03:51:02 +0200

Hi!,

I have a form that shows records from one table. Each record has a numeric
field named "priority".
I want the form to show the records sorted by the value in the "priority"
field, so that records with the lowest values (e.g 1,2) in their "priority"
field will be on the top, and records with the highest values (e.g. 10) in
that field will be at the bottom.
How can I do that?

Thanks!,
Amir.