Developer Forum

Assume an address string as
9988 Bladder Lane or 99-988 Gizard Road
What I want to do is create a search pattern that assumes
99%% Bladder Lane or 99-9%% Gizard Road
shares some characteristic (same side of the street & block,
with % odd on one side, and % even accross the street)

I think it is safe to assume the separation can be made on the first
occurnce of the space character. And the odd-even can be two digits to
the left of the first space (but cooler if the two can be easily
parametrised and tweaked, eg to 1 or 3).


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.yqcomputer.com/
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for *** s]

This following expression should return 0 or 1. So you can use that to
determine the even or odd side of the street.

Val(Right(Trim(Left([Address],Instr(1,[Address]," ")),1)) Mod 2

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Thanks


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.yqcomputer.com/
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for *** s]