why this wont work!!??

Hello,
I have a table (CONTACT) where we collect data from patient's visit.
There is a filed named 'visit' where IT is recorded the visit number. The
filed is settled as TEXT because visit can go from 1 to 20 and then from c1
to c12.
Snce it is text, I have used Access's conversion formula to filter data into
this field. But this wont work!!!
Here is the code:

SELECT CONTACT1.ID, CONTACT1.VISIT
FROM (SELECT ID, VISIT FROM CONTACT WHERE VISIT NOT LIKE 'c*') AS CONTACT1
WHERE CINT(CONTACT1.VISIT)>12

and always I receive the message: 'data type mismatch in criteria expression'.

Can help?
Thanks
.

Relevant Pages

  • Re: How to combine values from 2 fields for a report
    ... >> I get an error that says Data type mismatch in criteria expression when I try ... >>> In SQL ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: How to Remove Filter and Stay on Same Record
    ... This solved a "Data type mismatch in criteria Expression" error. ... Matt ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • get the sql statement
    ... Data type mismatch in criteria expression. ... Protected Sub btnSave_Click(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error 3464 with dCount - some computers only
    ... Error 3464 - Data type mismatch in criteria expression" from this line ... and produces a recordset with 36 records ... this code (and the print in the immediate window) ...
    (microsoft.public.access.formscoding)
  • >255 into excel?
    ... I need to insert more than 255 chars into an excelcolumn ... "Data type mismatch in criteria expression." ... ('VAFocus - ADH','Item cannot be found in the collection corresponding to ...
    (microsoft.public.inetserver.asp.db)