finding a record in a feild that won't fit the input mask

[Guest]

Sorry about the previous post.

I am changing the data type for a feild and it seems that there are a few
records in that feild that won't fit the mask. I don't want access to delete
them, but want to find the record and fix the three that will not work. The
data type is date/time. Is there a query that will pick out those three that
won't fit the data type?

thanks so much.

 

[Wolfgang Kais]

Hello "William5271".

I am changing the data type for a feild and it seems that there
are a few records in that feild that won't fit the mask. I don't
want access to delete them, but want to find the record and fix
the three that will not work. The data type is date/time. Is
there a query that will pick out those three that won't fit the
data type?

Sure. If you can find them yourself in datasheet view, there will
also be a way to use a query to filter thode three.
If you wnat to know, how the query looks like, you should tell us
what exacltly you want to change. Is the datatype date/time or
do you want to chage it to date/time? Are you trying the change
from text to date/time? - use the IsDate(...) function.
Changing datetime to text? - use the Len(CStr(...)) combination.