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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
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...
 
Back
Top