Is not null criteria

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

Guest

In my contacts database, I have FirstName, LastName, Company Fields. When
data is collected, many times all three of these fields are left blank within
the record. I have tried the Select query where I put [is not null] without
the brackets under each of these three fields and attempted an Update query
where the FirstName and LastName have Any Employee entered respectively. I
receive a result set of 0.

Since I am not familiar with VB Code, please explain what I am doing wrong
and what I need to do. Thanks.
 
You have stated what you have, what you tried (sort of), and your results but
not your objective. What do you want returned by your query? What does
"Update query" have to do with your question? Are you actually attempting to
change your values with this query?
 
Back
Top