I would like to do a lookup query to find the "closest" record based on matching a numeric attribute value with a number table value. In sql, I would do something like
SELECT TOP 1 * FROM [myTable] ORDER BY ABS( Area - @input )
But AF seem to not like the ABS() function in the WHERE clause of the lookup query.
Any suggestions to how I can get around this?