converted integer to string criteria

  • Thread starter Thread starter Don Cossitt
  • Start date Start date
D

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].
Code: 
),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
 
Back
Top