Re: Need to simplify Switch()

Tech-Archive recommends: Fix windows errors by optimizing your registry

As far as I can tell, my suggested expression will deal with
those examples. Maybe a set of rules to follow would explan
it better than the examples. OTOH, if you pasted the
expression that you tried along with the result it produced
and explained what is wrong with the result, I might be able
to figure it out.
--
Marsh
MVP [MS Access]


Nick X <Nicknnator (no) @ (spam) aol.123com> wrote:
>Thanks, unfortunately I haven't been able to get that last solution to work
>properly. Allow me to give some examples of how the final product should
>read. (These would be different records, just similar data):
>
>> >([strSingleAddress] Is Not Null [Street] Is Not Null And [From] Is Not Null And
>> >[To] Is Not Null And [Street Address or Location] Is Not Null,
>> >[strSingleAddress] & " " & [Street]
>> >& " between " & [From] & " and " & [To] & " - " & [Street Address or
>> >Location]
>
>Example: 123 N Main St between First St and Second St - on east side of street
>
>>[strSingleAddress] Is Null
>>And [Street] Is Not Null And [From] Is Not Null And [To] Is Not Null And
>>[Street Address or Location] Is Null,[Street] & " between " & [From] & " and
>>" & [To]
>
>Example: N Main St between First St and Second St
>
>>[strSingleAddress] Is Null And [Street] Is Not
>>Null And [From] Is Not Null And [To] Is Null And
>>[Street Address or Location] Is Not Null,[Street] & " at the corner of " & [From]>& " - " & [Street Address or Location]
>
>Example: N Main St at the corner of First St - NW Corner

.