Strange Row Numbering Problem..

  • Thread starter Thread starter Bill Mitchell
  • Start date Start date
B

Bill Mitchell

Hi,

I have added a Field called RowCounter to some of my
tables in which I want to be able to physically number
the rows on some continuous forms. The purpose of this
is for sorting, identifying, etc.

The problem that I am having is that since the field is
used sometimes and not used at other times, it
occasionally has a Null value. When sorting, Access
lists Null values FIRST. As you can see, this is a
problem.

Is there some way to set up my query so that it will sort
by the numbers RowCounter field ONLY if the value is NOT
NULL?

Thanks.
 
Sorting is an all or nothing proposition. You could format nulls to a
really large number like 9999 so that they will show at the bottom.
NZ([Number],9999) should do it. Or if you really dont want to show a number
you could create your query leaving out the records with nulls then union
the results with another query that returns only the nulls.

Kelvin
 
Back
Top