Hi,
Using Access 2000, I'm working with a table which was created from an
imported text file. The table contains a name field where the names
are entered like "DOE, JOHN A". I want to create a query to find all
the records that have a middle initial at the end of the string by
searching for a blank space at the next to last character.
I'm using "Mid([name],Len([name])-1,1)" as the expression which works
fine, but for the criteria I've tried comparing it to a blank (" "),
a zero length string (""), or a Null value, and I get a data type
mismatch error.
I've done some research and have tried using MidB and LenB, but that
hasn't worked. I also read about byte storage, Unicode and ANSI
storage, and checking for a dll file, but nothing that has been
helpful to me. Does anyone have any suggestions what's wrong and how
to test for this condition?
Thanks very much,
Rick
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
