Re: query records by numbers column with blank records showing last

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Order by [TheField] is Null Desc, [TheField]

If you are doing this in the query grid, add a calculated column. In front of
the column Number column if you are using the grid.

FIeld: [TheTable].[TheField] is Null
Sort By: descending
Show : Unchecked

An alternative, if your numbers column has a known maximum is to sort by NZ([TheNumberField],10000000000)
That assumes that 10000000000 is larger than any number you have in the number
field (and it will fail to sort property for you if you ever do get the larger number.


JMT203 wrote:
>
> I want to query the numbers column to show my records in numeric order. By
> default it shows the records without a number assigned, first. I want those
> records to be displayed at the end.
.

Relevant Pages

  • Help Needed With Format Of Query Expression
    ... I'm using the following expression in the query grid to show the Month ... Is there a different way that it can be formatted so that when I sort ... aggregate function and if I Group on TxtDate or use Min or Max the ...
    (comp.databases.ms-access)
  • Re: Access Query to request record with date closest to todays dat
    ... The query grid is a graphic view of SQL that has a section at the bottom (a ... Field: SomeDate ... Sort: Descending ... additional sort criteria. ...
    (microsoft.public.access.queries)
  • Re: Query Order By then By...
    ... In the query grid, there is a sort by line. ... I know you can do multi-tiered sorting in a report, ...
    (microsoft.public.access.queries)
  • Re: alphabetic sort problem
    ... why does the sort work in the query grid using the A-Z ... The Report processing ignores the sorting in your Query! ...
    (microsoft.public.access.queries)
  • RE: Sorting alphanumeric
    ... other "'" came out after the regular numbers. ... "Joanne" wrote: ... > I would like to sort some text which is formatted in column one as: ... Prev by Date: ...
    (microsoft.public.excel.misc)