Have you ever seen anything like this?

[ChampionDuy]

This is very strange. I have a query which is shown below.

SELECT Mid$([DCN/Serial_No],1,3) AS DCN, [Subject], [Action_Complete]
FROM newtaskerform
WHERE (((Mid$([DCN/Serial_No],1,3))="SMC"));

When I run this query, I get the anticipated information back, then about 3 seconds later I get an error messsage saying that there is a data type mismatch. I hit OK and then all the info in the query turns to #Name?. I have played with the query and I can not figure out why this happens. It is very strange since when I run the Query I do get the info back, then 3 seconds later I get an error message.

Now this is where is get even more confusing. I saved the query as a report and that works fine. It gives me all the info and no error messages. Have you guys ever seen anything like this? I can elaborate more if needed.

 

[pdx_man]

Try:

SELECT CStr(Mid$([DCN/Serial_No],1,3)) AS DCN, [Subject], [Action_Complete]
FROM newtaskerform
WHERE (((CStr(Mid$([DCN/Serial_No],1,3)))="SMC"));

The Mid$ function is resoving to some numbers ocasionally and that is when it gets confused.

 

[ChampionDuy]

I tried it but I eneded up getting the same thing. This is the strangest thing I have seen from Access in a while. But the report works so thats all that matters. I just hope it does not give me problems in the future.
Thanks again