I WOULD LIKE TO DESCRIBE MY PROBLEM WITH AN EXAPLE. I HAVE A TABLE say table1 IN MS-ACCESS WITH DATA OUT OF 5 RECORDS ABOVE, THERE ARE TWO RECORDS WHERE ONE COLUMN IS MISSING. NOW WHEN I GIVE QUERRY ...