Ralf: The data has nulls in it. For example, one grid is equivalent to a checking account, with deposits and checks. The column for the check number is null for deposits. Another table has three different phone number fields, not everybody has three phone numbers. Another table has employee termination date, current employees have none.
As you can see it is a ubiquitous problem and this is in a small part of the application. I could cause the queries to replace nulls with some reasonable data for sorting, but it wouldn't look right to the user. Paul --- In flexcoders@yahoogroups.com, "Ralf Bokelberg" <[EMAIL PROTECTED]> wrote: > > Why has you data null values in the first place? > Maybe you can put in some dummy data? > Cheers > Ralf. >