A
Ann Scharpf
I am trying to create a case sensitive query that identifies when users have
made typos when entering the word TO. I read postings here and have gotten
the StrComp to get me most of the way I need to go. My query is giving
correct 1 and 0 results depending on whether there is a typo in the line.
I am having trouble getting to the next step of LIMITING my results to lines
that have the error condition. My query is producing a 1065 line result.
Only 5 of these lines have a TO typo.
Here is my SQL:
SELECT tbl.Fld, InStr(1,[fld],"-To-") AS ToPos, StrComp(Mid([Fld],InStr([Fld],
"to"),2),"TO",0) AS ToError
FROM tbl
GROUP BY tbl.Fld, InStr(1,[fld],"-To-"), StrComp(Mid([Fld],InStr([Fld],"to"),
2),"TO",0)
HAVING (((tbl.Fld) Like "*to*"));
I tried to change the ToError so that it had a "where >0" condition, so that
I'd only see the rows that have a 1, indicating the error. When I try the
"where", I get error "Data type mismatch in criteria expression."
Is there any way to limit my results so I only see the error rows?
Thanks for your help.
Ann
made typos when entering the word TO. I read postings here and have gotten
the StrComp to get me most of the way I need to go. My query is giving
correct 1 and 0 results depending on whether there is a typo in the line.
I am having trouble getting to the next step of LIMITING my results to lines
that have the error condition. My query is producing a 1065 line result.
Only 5 of these lines have a TO typo.
Here is my SQL:
SELECT tbl.Fld, InStr(1,[fld],"-To-") AS ToPos, StrComp(Mid([Fld],InStr([Fld],
"to"),2),"TO",0) AS ToError
FROM tbl
GROUP BY tbl.Fld, InStr(1,[fld],"-To-"), StrComp(Mid([Fld],InStr([Fld],"to"),
2),"TO",0)
HAVING (((tbl.Fld) Like "*to*"));
I tried to change the ToError so that it had a "where >0" condition, so that
I'd only see the rows that have a 1, indicating the error. When I try the
"where", I get error "Data type mismatch in criteria expression."
Is there any way to limit my results so I only see the error rows?
Thanks for your help.
Ann