converted integer to string criteria

[Don Cossitt]

I have a five digit integer in a 'code' field in need to query off of the
fourth digit. I have tried putting
Left$(Str([neiborhood_codes_bm].

),4)="1" in the criteria field but
returns empty resultset.

'code' format is five digits ranging from 0-9 for each digit.  EG 11211.
Digits represent: location, zone, scope, condition, function.  I am trying
to query on digit four - 'condition'.

TIA

doco

 

[George Nicholson]

Iif(Mid([neiborhood_codes_bm].

,4,1) = "1", WhenTrue, WhenFalse)