Strange Row Numbering Problem..

[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.

 

[Kelvin]

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