#Error in query

[rookie]

I created an IIf statement in my query and it somewhat works. When I ran it,
the "False" showed up as "False". However, the "True" showed up as "#Error".
Why is that?

Ab without Asp: IIf([Non-Asp Findings]="True" And [Normal
Swallow]="False","True","False")

Thanks!
Rookie

 

[rookie]

Hi Dale Fye,
The "Normal Swallow" field is a Yes/No. The "Non-asp findings" was created
in another query as an expression.

I do not see the check boxes for the Yes/No field because I imported the
data from an excel file into Access 2003. Afterwards, I converted the "Normal
Swallow" field into a "Yes/No".

Therefore, I'm lost why it doesn't work... could it be that it's not a true
yes/no field?

Rookie,

Are the fields [Non-asp Findings] and [Normal Swallow] text fields or Yes/No?

If you want to store True/False type values in a table, I would recommend
the Yes/No datatype, which can be displayed as a checkbox. The advantage of
this method is that you don't actually have to test for "True" or "False",
you just create a logical expression.

Ab without ASP = [Non-Asp Findings] AND (NOT [Normal Swallow])

You might be running into a situation where one of the two fields contains a
NULL value, although the test for (NULL = "False") will evaluate to NULL, and
so will (NULL = "True"), so I'm not sure why this would cause an error.
----
HTH
Dale

I created an IIf statement in my query and it somewhat works. When I ran it,
the "False" showed up as "False". However, the "True" showed up as "#Error".
Why is that?

Ab without Asp: IIf([Non-Asp Findings]="True" And [Normal
Swallow]="False","True","False")

Thanks!
Rookie

 

[Dale Fye]

If it truely is a Yes/No field, then you cannot wrap the value in quotes,
you need to test against the boolean value. Try

Ab without Asp: IIf(([Non-Asp Findings]="True") And ([Normal Swallow]=
False),"True","False")

Dale

Hi Dale Fye,
The "Normal Swallow" field is a Yes/No. The "Non-asp findings" was created
in another query as an expression.

I do not see the check boxes for the Yes/No field because I imported the
data from an excel file into Access 2003. Afterwards, I converted the
"Normal
Swallow" field into a "Yes/No".

Therefore, I'm lost why it doesn't work... could it be that it's not a
true
yes/no field?

Rookie,

Are the fields [Non-asp Findings] and [Normal Swallow] text fields or
Yes/No?

If you want to store True/False type values in a table, I would recommend
the Yes/No datatype, which can be displayed as a checkbox. The advantage
of
this method is that you don't actually have to test for "True" or
"False",
you just create a logical expression.

Ab without ASP = [Non-Asp Findings] AND (NOT [Normal Swallow])

You might be running into a situation where one of the two fields
contains a
NULL value, although the test for (NULL = "False") will evaluate to NULL,
and
so will (NULL = "True"), so I'm not sure why this would cause an error.
----
HTH
Dale

I created an IIf statement in my query and it somewhat works. When I
ran it,
the "False" showed up as "False". However, the "True" showed up as
"#Error".
Why is that?

Ab without Asp: IIf([Non-Asp Findings]="True" And [Normal
Swallow]="False","True","False")

Thanks!
Rookie

 

[rookie]

Hi Dale,
I tried your recommendation below and it didn't work. However, I did figure
it out by creating 2 separate IIf statement and it worked!

Thanks!
Rookie

If it truely is a Yes/No field, then you cannot wrap the value in quotes,
you need to test against the boolean value. Try

Ab without Asp: IIf(([Non-Asp Findings]="True") And ([Normal Swallow]=
False),"True","False")

Dale

Hi Dale Fye,
The "Normal Swallow" field is a Yes/No. The "Non-asp findings" was created
in another query as an expression.

I do not see the check boxes for the Yes/No field because I imported the
data from an excel file into Access 2003. Afterwards, I converted the
"Normal
Swallow" field into a "Yes/No".

Therefore, I'm lost why it doesn't work... could it be that it's not a
true
yes/no field?

Rookie,

Are the fields [Non-asp Findings] and [Normal Swallow] text fields or
Yes/No?

If you want to store True/False type values in a table, I would recommend
the Yes/No datatype, which can be displayed as a checkbox. The advantage
of
this method is that you don't actually have to test for "True" or
"False",
you just create a logical expression.

Ab without ASP = [Non-Asp Findings] AND (NOT [Normal Swallow])

You might be running into a situation where one of the two fields
contains a
NULL value, although the test for (NULL = "False") will evaluate to NULL,
and
so will (NULL = "True"), so I'm not sure why this would cause an error.
----
HTH
Dale



:

I created an IIf statement in my query and it somewhat works. When I
ran it,
the "False" showed up as "False". However, the "True" showed up as
"#Error".
Why is that?

Ab without Asp: IIf([Non-Asp Findings]="True" And [Normal
Swallow]="False","True","False")

Thanks!
Rookie

.

 

[Dale Fye]

Rookie,

What did your final code look like:

Dale

Hi Dale,
I tried your recommendation below and it didn't work. However, I did
figure
it out by creating 2 separate IIf statement and it worked!

Thanks!
Rookie

If it truely is a Yes/No field, then you cannot wrap the value in quotes,
you need to test against the boolean value. Try

Ab without Asp: IIf(([Non-Asp Findings]="True") And ([Normal Swallow]=
False),"True","False")

Dale

Hi Dale Fye,
The "Normal Swallow" field is a Yes/No. The "Non-asp findings" was
created
in another query as an expression.

I do not see the check boxes for the Yes/No field because I imported
the
data from an excel file into Access 2003. Afterwards, I converted the
"Normal
Swallow" field into a "Yes/No".

Therefore, I'm lost why it doesn't work... could it be that it's not a
true
yes/no field?

:

Rookie,

Are the fields [Non-asp Findings] and [Normal Swallow] text fields or
Yes/No?

If you want to store True/False type values in a table, I would
recommend
the Yes/No datatype, which can be displayed as a checkbox. The
advantage
of
this method is that you don't actually have to test for "True" or
"False",
you just create a logical expression.

Ab without ASP = [Non-Asp Findings] AND (NOT [Normal Swallow])

You might be running into a situation where one of the two fields
contains a
NULL value, although the test for (NULL = "False") will evaluate to
NULL,
and
so will (NULL = "True"), so I'm not sure why this would cause an
error.
----
HTH
Dale



:

I created an IIf statement in my query and it somewhat works. When I
ran it,
the "False" showed up as "False". However, the "True" showed up as
"#Error".
Why is that?

Ab without Asp: IIf([Non-Asp Findings]="True" And [Normal
Swallow]="False","True","False")

Thanks!
Rookie

.