or statement problems

[kalkap]

I'm using the IIF function with the OR statement in a query. The issue I'm having is that the expression will return the proper result if the true statement is true but is giving the #Error instead of the if false value?

The expression I'm using is:

IIf([Outage Due(Raw)]="26" Or [2nd Due]="26",[PMRQ Title],"N/A")



Here is selected screenshot of the result using the above expression if that helps anyone.
https://docs.google.com/document/d/1...it?usp=sharing

I'm sure there is an easy reason but I can't seem to figure it out. I would appreciate any insight anyone might have. Thanks.

[June7]

I can't view that image now (blocked). If you attached it to post I could view.

This is an expression to construct a field in query?

I can't see anything wrong with it.

[kalkap]

I can't view that image now (blocked). If you attached it to post I could view.

This is an expression to construct a field in query?

I can't see anything wrong with it.

Sorry about the link. It worked before I posted it, but I have attached it here. I'm on the novice side using Access but if I understand you correctly, I am using an expression to construct a field.

[June7]

I expect the link was good, I was simply blocked (IT restrictions).

I can barely see another field showing #Error but can't see the fields used in the expression.

Unfortunately, that image doesn't help find the cause.

Next step is to provide the db. If you want, follow instructions at bottom of my post.

[kalkap]

I expect the link was good, I was simply blocked (IT restrictions).

I can barely see another field showing #Error but can't see the fields used in the expression.

Unfortunately, that image doesn't help find the cause.

Next step is to provide the db. If you want, follow instructions at bottom of my post.

I have attached a small excerpt of the database containing only the Table and Query that are used. I have a table of several hundred component maintenance tasks that are done on specified frequencies. I'm trying to use the query to project where each of the maintenance tasks fall in the 2nd, 3rd, 4th etc interval out. If you look at the query and start with the U1C26 column, that is where my issue starts. As you will see, the U1C26 column is an expression that is reading from another column containing an expression.

I appreciate the help.

[lfpm062010]

Problem is that you are compare number against text.

U1C26: IIf([Outage Due(Raw)]="26" Or [2nd Due]=26,[PMRQ Title],"N/A")
[Outage Due(Raw)] is text. [2nd Due] is number. I remove the double quote and the expression worked. I guess is the same problem for all the others as well.

[kalkap]

Problem is that you are compare number against text.

U1C26: IIf([Outage Due(Raw)]="26" Or [2nd Due]=26,[PMRQ Title],"N/A")
[Outage Due(Raw)] is text. [2nd Due] is number. I remove the double quote and the expression worked. I guess is the same problem for all the others as well.

That worked! Thank you. This text vs number concept has been my biggest headache in moving over from Excel to Access. Thanks again.