troubleshooting Question

Help building query - query error - Data type mismatch in criteria expression

Avatar of steveca
steveca asked on
Microsoft Access
14 Comments1 Solution297 ViewsLast Modified:
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
FROM 9072
WHERE ((([9072].Field5)="closed"));

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."


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros