Sorting problems....

  • Thread starter Thread starter Preston
  • Start date Start date
P

Preston

OK I have a table that has columns "Firstname", "Lastname",
and "Company". I want to sort on "Company" but not
everyone has a company name so I want it to sort or orderby
A - Z or ascending then have all the null after the A - Z
at the bottom of the list or records. Please help.....much
thanks in advance!!!
 
Probably a dumb fix, but if no one else answers, try it.
Create new column in table with value of 0 or 1. If
company name is null, value 1, otherwise value 0. Sort
this field ascending, then sort by company name
ascending. You should have what you want.
-----Original Message-----
OK I have a table that has
Click to expand...
columns "Firstname", "Lastname",
 
Back
Top