Sorting / Filtering blanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All new to access and finding my feet ..

Have created as database with 10000+ entries ... I am trying to create a
Query to idntify erros in a column... All employee number should be 6 digits
so I have creater the query for my new table to show me all employee whos
number is length less than six (Len[EmpNo] <6 ... this works fine, however I
have a number of employees who have no number entered for employee no and
these cells are blank ... how do I include them ... the Len Query does not
work

Any help appreciated
 
In the query builder underneath where you have (Len[EmpNo] <6; type
isnull. This will add all null fields to your query.

John
 
Alan said:
Hello All new to access and finding my feet ..

Have created as database with 10000+ entries ... I am trying to create a
Query to idntify erros in a column... All employee number should be 6 digits
so I have creater the query for my new table to show me all employee whos
number is length less than six (Len[EmpNo] <6 ... this works fine, however I
have a number of employees who have no number entered for employee no and
these cells are blank ... how do I include them ... the Len Query does not
work

Any help appreciated
Click to expand...
Ty Is Null for criteria or = " "
 
Back
Top