Sorting problems....

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!!!
 
L

Les

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",
 
Top