How do I put a list of number in order in a query

G

Gilbo

I have a football league table that works fine, but I don't know how to put a
column with the position in the league, (1 - 12)
 
K

KARL DEWEY

If the column (field) with the position in the league is a number then just
sort on the field. If it is text then add a calculated field like this --
League Position: Right("0" & [YourPositionField], 2)
and then sort on it. Turn off the display by un-clicking the checkbox in
design view.
 
K

KARL DEWEY

Open the query in design view. Uncheck the display checkbox and add the
normal field for display by draging it down or double clicking the field name.

gil_wilkes said:
Thanx for that, but how do I remove the leading zero (01, 02) to show (1, 2)

KARL DEWEY said:
If the column (field) with the position in the league is a number then just
sort on the field. If it is text then add a calculated field like this --
League Position: Right("0" & [YourPositionField], 2)
and then sort on it. Turn off the display by un-clicking the checkbox in
design view.

Gilbo said:
I have a football league table that works fine, but I don't know how to put a
column with the position in the league, (1 - 12)
Click to expand...
Click to expand...
Click to expand...
 
Top