[AccessD] less than on text field

[Susan Harkins]

Are you querying a text field against an Integer? 

Susan H. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
John R Bartow
Sent: Tuesday, December 15, 2015 2:47 PM
To: DBA-Access <AccessD at databaseadvisors.com>
Subject: [AccessD] less than on text field
Importance: High

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