[AccessD] less than on text field

[Gary Kjos]

Don't know about MySQL but wouldn't it be

[as_software]![version] < '11'

since it's a text field

Or

Val([as_software]![version]) < 11

which would give you the numeric value of the characters in the text field ?

On Tue, Dec 15, 2015 at 1:46 PM, 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



-- 
Gary Kjos
garykjos at gmail.com