IFF Function help please

[Golfinray]

I have struggled my guts out studying IFF and str functions over the years
and I still have problems with certain ones. I just have not been able to get
this one to work. I have district name-projectsomething in a field. So it may
be fayeteville-electrical, batesville-roofs, Little Rock-plumbing,
cabot-fireprotection or similar. I would like just to return the school
district name without the -something. Thanks so much!!!

 

[Klatuu]

This doesn't require an Iif statment. This formula will return what you want.

Left(Nz([districtname],"-"),Instr(Nz([districtname],"-"),"-")-1)

If [districtname] is Null, the formula will return a null string ""

 

[Golfinray]

Thanks Fred. That worked great. Golfinray

This doesn't require an Iif statment. This formula will return what you want.

Left(Nz([districtname],"-"),Instr(Nz([districtname],"-"),"-")-1)

If [districtname] is Null, the formula will return a null string ""
--
Dave Hargis, Microsoft Access MVP

I have struggled my guts out studying IFF and str functions over the years
and I still have problems with certain ones. I just have not been able to get
this one to work. I have district name-projectsomething in a field. So it may
be fayeteville-electrical, batesville-roofs, Little Rock-plumbing,
cabot-fireprotection or similar. I would like just to return the school
district name without the -something. Thanks so much!!!

 

[Golfinray]

Sorry, I meant Dave. Thanks

Thanks Fred. That worked great. Golfinray

This doesn't require an Iif statment. This formula will return what you want.

Left(Nz([districtname],"-"),Instr(Nz([districtname],"-"),"-")-1)

If [districtname] is Null, the formula will return a null string ""
--
Dave Hargis, Microsoft Access MVP

I have struggled my guts out studying IFF and str functions over the years
and I still have problems with certain ones. I just have not been able to get
this one to work. I have district name-projectsomething in a field. So it may
be fayeteville-electrical, batesville-roofs, Little Rock-plumbing,
cabot-fireprotection or similar. I would like just to return the school
district name without the -something. Thanks so much!!!

 

[raskew via AccessMonster.com]

For what it's worth: It's IIF(), not IFF().

Bob

 

[fredg]

Thanks Fred. That worked great. Golfinray

This doesn't require an Iif statment. This formula will return what you want.

Left(Nz([districtname],"-"),Instr(Nz([districtname],"-"),"-")-1)

If [districtname] is Null, the formula will return a null string ""
--
Dave Hargis, Microsoft Access MVP

I have struggled my guts out studying IFF and str functions over the years
and I still have problems with certain ones. I just have not been able to get
this one to work. I have district name-projectsomething in a field. So it may
be fayeteville-electrical, batesville-roofs, Little Rock-plumbing,
cabot-fireprotection or similar. I would like just to return the school
district name without the -something. Thanks so much!!!

You're welcome! Anytime. <g>