record sorting

[Tom Burke]

I have created a query which gives me a points league table in descending
order, but if two teams both have the same number of points it gives me
alphabetical sort but i want to sort in an order of who wins a play off which
could be non alphabetical .
Can any one please help

 

[fredg]

I have created a query which gives me a points league table in descending
order, but if two teams both have the same number of points it gives me
alphabetical sort but i want to sort in an order of who wins a play off which
could be non alphabetical .
Can any one please help

How do you determine who is in the playoff?
Do you have a [Playoff] field?
If so, what are the anticipated values? Hopefully Yes or No (-1 or 0).

Basically, include the Playoff field, then sort the query on [Points]
and also [Playoff]. Sort this column Ascending.
As Access sorts queries in left to right order, just drag the
[Playoff] column to the right of the [Points] column.

If there is a tie in the [Points] field, the [Playoff] Yes value will
sort before the [Playoff] No value.

 

[Wayne-I-M]

Hi

Do you have field in your table/query that denotes who won a play off and if
you do how is this recorded

 

[Tom Burke]

Thanks wayne for the reply but no i dont have a field that denotes who won