[AccessD] less than on text field

[John R Bartow]

No, it returns an error in the query rows.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David McAfee
Sent: Tuesday, December 15, 2015 3:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] less than on text field

Does this work:

VerNum: CINT(NZ(TRIM([as_software]![version]),0))

On Tue, Dec 15, 2015 at 11:46 AM, John R Bartow <jbartow at winhaven.net>
wrote:

> I have a text field "version" in a MySQL DB, I connect to the DB with 
> A2013, I make a query of the data and only want to show the results 
> where version is less than 11.
>
> VerNum: Val([as_software]![version]) returns an integer - why can't I 
> filter this with the criteria: < 11 ?
>
>
>
> TIA
>
> John
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com