Create IIf Statement for Query

[k7i5t3n]

I have two tables I'm using in a query. I have pulled several fields
from 'tblEmployeeList' and need to pull a Yes/No field
'FileStampNumber' from the table 'tblFileStamps'. However, I need to
create a statement saying that if field 'CurrentFile-Stamp?' is true,
then display 'FileStampNumber', else "N/A". I have written the
statement as follow:

IIf([tblFileStamps]![CurrentFile-Stamp?]=True,[tblFileStamps]![FileStampNumber],"N/A")

The field name in the query is 'FileStampNumber'. When I run the query
though, I get the error message that "The expression is typed
incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables."

Does anyone know how I do this or if creating variables would fix the
problem? Thanks in advance!

[dkintheuk]

Hi there,

Have you tried to remove the questionmark? It could cause many problems
for Access as it tries to work out what you mean...

Rob.

i5t3n wrote:

I have two tables I'm using in a query. I have pulled several fields
from 'tblEmployeeList' and need to pull a Yes/No field
'FileStampNumber' from the table 'tblFileStamps'. However, I need to
create a statement saying that if field 'CurrentFile-Stamp?' is true,
then display 'FileStampNumber', else "N/A". I have written the
statement as follow:

IIf([tblFileStamps]![CurrentFile-Stamp?]=True,[tblFileStamps]![FileStampNumber],"N/A")
The field name in the query is 'FileStampNumber'. When I run the query though, I get the error message that "The expression is typed
incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables."

Does anyone know how I do this or if creating variables would fix the
problem? Thanks in advance!

[k7i5t3n]

Ok, I tested by removing the question mark, to no avail. Thanks for the
input though!! Let me know if you have any other ideas - much
appreciated!

Kristen