Nested IIf Statement

[Guest]

Good Morning

I'm working on a Nested IIf Statement, I have resolved the first part, but I
am getting stuck when I add the second part.

Here's my IIf statement!

IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND,
(IIf(cable.TGLAND like 'H*',mid(cable.TGLAND, 2),cable.TGLAND)) AS
CONNECT_TYPE,

Thank you

 

[Duane Hookom]

Can you describe in one or more sentences what you would like to return with
this expression? Also, I would use
Left(cable.FGLAND,1) = 'H'
rather than
cable.FGLAND like 'H*'

Also, Mid() generally likes 3 arguments. If you ommit the last one, all the
characters are returned following the second argument. I assume this is what
you want.

 

[Guest]

Hello - my apolgies for the length of this explanation

I did look up the mid function to confirm that is what I want to use
Mid(string, start[, length]) - I just haven't put a length on the end

Here's what I want - I have two gland ends one of which might be hazardous
I'm required to show but I've just preceded the gland code by the letter H.
I don't want to show the H. If neither end is hazardous then I need to show
the glandcode from either the TGLAND or the FGLAND - which is the same
glandcode.

This part works
IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND) AS CONNECT_TYPE,

and it returned the values that I was expecting, but I need to make sure I
capture any hazardous gland ends from the TGLAND end.

regards,

 

[John Spencer]

IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),
IIf(cable.TGLAND like 'H*',mid(cable.TGLAND, 2),cable.TGLAND)) AS
CONNECT_TYPE

Hello - my apolgies for the length of this explanation

I did look up the mid function to confirm that is what I want to use
Mid(string, start[, length]) - I just haven't put a length on the end

Here's what I want - I have two gland ends one of which might be hazardous
I'm required to show but I've just preceded the gland code by the letter
H.
I don't want to show the H. If neither end is hazardous then I need to
show
the glandcode from either the TGLAND or the FGLAND - which is the same
glandcode.

This part works
IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND) AS
CONNECT_TYPE,

and it returned the values that I was expecting, but I need to make sure I
capture any hazardous gland ends from the TGLAND end.

regards,
--
jkb66

Can you describe in one or more sentences what you would like to return
with
this expression? Also, I would use
Left(cable.FGLAND,1) = 'H'
rather than
cable.FGLAND like 'H*'

Also, Mid() generally likes 3 arguments. If you ommit the last one, all
the
characters are returned following the second argument. I assume this is
what
you want.

 

[Duane Hookom]

How about just showing us some raw data and what you would expect to see in
your column?
Is it possible that both gland ends might be hazardous?

--
Duane Hookom
MS Access MVP
--

Hello - my apolgies for the length of this explanation

I did look up the mid function to confirm that is what I want to use
Mid(string, start[, length]) - I just haven't put a length on the end

Here's what I want - I have two gland ends one of which might be hazardous
I'm required to show but I've just preceded the gland code by the letter
H.
I don't want to show the H. If neither end is hazardous then I need to
show
the glandcode from either the TGLAND or the FGLAND - which is the same
glandcode.

This part works
IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND) AS
CONNECT_TYPE,

and it returned the values that I was expecting, but I need to make sure I
capture any hazardous gland ends from the TGLAND end.

regards,
--
jkb66

Can you describe in one or more sentences what you would like to return
with
this expression? Also, I would use
Left(cable.FGLAND,1) = 'H'
rather than
cable.FGLAND like 'H*'

Also, Mid() generally likes 3 arguments. If you ommit the last one, all
the
characters are returned following the second argument. I assume this is
what
you want.

 

[Guest]

I wanted to thank you for your all suggestions, I'm going to try and tackle
it with a switch function at this time. Which I can post if I have any luck.

cheers!
--
jkb66

How about just showing us some raw data and what you would expect to see in
your column?
Is it possible that both gland ends might be hazardous?

--
Duane Hookom
MS Access MVP
--

Hello - my apolgies for the length of this explanation

I did look up the mid function to confirm that is what I want to use
Mid(string, start[, length]) - I just haven't put a length on the end

Here's what I want - I have two gland ends one of which might be hazardous
I'm required to show but I've just preceded the gland code by the letter
H.
I don't want to show the H. If neither end is hazardous then I need to
show
the glandcode from either the TGLAND or the FGLAND - which is the same
glandcode.

This part works
IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND) AS
CONNECT_TYPE,

and it returned the values that I was expecting, but I need to make sure I
capture any hazardous gland ends from the TGLAND end.

regards,
--
jkb66

Can you describe in one or more sentences what you would like to return
with
this expression? Also, I would use
Left(cable.FGLAND,1) = 'H'
rather than
cable.FGLAND like 'H*'

Also, Mid() generally likes 3 arguments. If you ommit the last one, all
the
characters are returned following the second argument. I assume this is
what
you want.

--
Duane Hookom
MS Access MVP
--

Good Morning

I'm working on a Nested IIf Statement, I have resolved the first part,
but
I
am getting stuck when I add the second part.

Here's my IIf statement!

IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND,
(IIf(cable.TGLAND like 'H*',mid(cable.TGLAND, 2),cable.TGLAND)) AS
CONNECT_TYPE,

Thank you