I'm using Access 2000 and I'm running into problems with a Query.
Here is what I have from the SQL view:
SELECT DateValue(2000+Mid([Field1],8,2) & "/" & Mid([Field1],2,2) & "/" & Mid([Field1],5,2))+TimeValue(Mid([Field1],11,8)) AS DateTimeStop, Left([Field3],Len([Field3])-1) AS IPAddress, Val(Right([Field6],Len([Field6])-1)) AS Seconds, 24 AS Stream
What I'd like to do is to further restrict the query to records where the Seconds column has a value of 10 or greater. When I do this, I get "Data type mismatch in criteria expression."