table with different datatypes

[scott]

I have a table with field that has employee numbers that
are 7 digits long..

If the employee does not have an employee number yet..the
user uses the employees name so the field looks something
like this.

1234563
5664787
scott
dave
3214566

I when I make a query from this it looks like this
1234563
5664787
#Num!
#Num!
3214566

I want to create a query that JUST shows the #Num!
(employees that dont have employee numbers yet)

The field is a numeric...I have it linked and even though
I changed the excel field to text or general..it still
links as numeric....

I tried using IS NULL and I get numeric overflow errors.

How would I create a query that would just bring back the
2 names?

thanks
Scott

 

[Rick Brandt]

I have a table with field that has employee numbers that
are 7 digits long..

If the employee does not have an employee number yet..the
user uses the employees name so the field looks something
like this.

1234563
5664787
scott
dave
3214566

I when I make a query from this it looks like this
1234563
5664787
#Num!
#Num!
3214566

I want to create a query that JUST shows the #Num!
(employees that dont have employee numbers yet)

The field is a numeric...I have it linked and even though
I changed the excel field to text or general..it still
links as numeric....

I tried using IS NULL and I get numeric overflow errors.

How would I create a query that would just bring back the
2 names?

The linking wizard will examine the first dozen or so rows and then "guess"
at the DataType based on that. If you make sure the first row has text in
it when creating the link then Access should treat it as a text field.
Then you can use the IsNumeric() function to find the rows where the field
does not contain a number.