I'm sure this is really simple, but having a major senior moment.
I'm trying to retrieve data from one table, but filtered using data from another table. Usually pretty simple using NL("Filter"....
However, I would like to filter on the first 6 characters of a field.
In SQL : Select Field From Table1 Where Left(Field,6) in (Select Field2 From Table2)
I've tried various methods of getting the LEFT(Field,6) bit to work but so far to no avail.eg. NL("Rows","Table1","Field","LEFT(Field,6)",NL("Filter","Table2","Field2")
Any help would be much appreciated.