Sort by criteria

  • Thread starter Thread starter =?iso-8859-1?B?Qmr2cm4=?=
  • Start date Start date
?

=?iso-8859-1?B?Qmr2cm4=?=

Is it possible to have a query to sort all dates before a
specific date in on way (col1 asc.) and after the same
date in an other way (col2 asc.)

Col0 | Date | Col1 | Col2 |

I hope that somebody can give me a hint of how do do this
// Björn
 
Hi,


Sure. ORDER BY allows computed expressions. If I understand your
requirements, that may look like


ORDER BY iif( [date] <= specificDate, col1, col2) ASC




Hoping it may help,
Vanderghast, Access MVP



Is it possible to have a query to sort all dates before a
specific date in on way (col1 asc.) and after the same
date in an other way (col2 asc.)

Col0 | Date | Col1 | Col2 |

I hope that somebody can give me a hint of how do do this
// Björn
 
Back
Top