[AccessD] less than on text field

[David McAfee]

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
>