IF OR Statement help

**anoble1** · 05-13-2025, 08:14 AM

I need some help, I keep getting errors in my query when I add a or as in it doesn't display what I am looking for.

Code:

Expr1: IIf([dbo_vw_ReportingInfo]![Location Type]="FULL SERVICE" Or "LIMITED ACCESS","FULL","OTHER")

This is the Column Heading of a crosstab query. I would like there to be 2 columns at the top. First column would be "Full" which would include the Location Types of: Full Service or Limited Access. The second column would add all other types up. When I run the query as is it just has 1 column for full service.

**Gicu** · 05-13-2025, 08:22 AM

Try these:

Code:

IIf([dbo_vw_ReportingInfo]![Location Type]="FULL SERVICE" Or [dbo_vw_ReportingInfo]![Location Type]= "LIMITED ACCESS","FULL","OTHER")

Code:

IIf([dbo_vw_ReportingInfo]![Location Type] IN ("FULL SERVICE","LIMITED ACCESS"),"FULL","OTHER")

Cheers,

**Micron** · 05-13-2025, 08:23 AM

Each portion needs to be able to stand on it's own. Your second portion says Or "LIMITED ACCESS". If I walked up to you and said that, you'd think I was crazy.

I didn't re-write it because it's not clear what you expect. You want FULL if the field contains either of those words, and OTHER if it doesn't? Or you want FULL if it's FULL SERVICE and OTHER if it's LIMITED ACCESS. I think it is the former though. Anyway, you should be able to fix it by repeating the field reference.

**Welshgasman** · 05-13-2025, 08:24 AM

You need to repeat the test

Code:

Expr1: IIf([dbo_vw_ReportingInfo]![Location Type]="FULL SERVICE" Or [dbo_vw_ReportingInfo]![Location Type]= "LIMITED ACCESS","FULL","OTHER")

Might be able to use IN()

Code:

Expr1: IIf([dbo_vw_ReportingInfo]![Location Type] IN ("FULL SERVICE", "LIMITED ACCESS"),"FULL","OTHER")

**anoble1** · 05-13-2025, 09:51 AM

The first one worked great! Thanks for the help. That crossed my mind, but I didn't think it would matter.

Originally Posted by Gicu

Try these:

Code:

IIf([dbo_vw_ReportingInfo]![Location Type]="FULL SERVICE" Or [dbo_vw_ReportingInfo]![Location Type]= "LIMITED ACCESS","FULL","OTHER")

Code:

IIf([dbo_vw_ReportingInfo]![Location Type] IN ("FULL SERVICE","LIMITED ACCESS"),"FULL","OTHER")

Cheers,

**Welshgasman** · 05-13-2025, 10:29 AM

Well, it wouldn't hurt to try?

IF OR Statement help

Thread Tools

IF OR Statement help

Similar Threads

I have been struggling with my "if statement" and my "do until end of file statement"

Problem: Creating an IIF statement in a BETWEEN statement for dates

if statement in sql statement, query builder

bad syntax error on sql statement used in a openrecordset statement

multiple iif statement NEED HELP PLZ

Posting Permissions