A
Andrew Bokelman
I am using Access 2003 SP2. In a query, I have created an expression
called "check." In some cases it returns an error in the form of
#Error." I want to add to my query so it will show only those records
that have an #Error in my check field.
I tried entering #Error into the criteria area, with and with out
quotes. I also tried creating a second criteria that says
iif(iserror([check]), "prob", "")
All that does is give me another #Error, if it finds an #Error.
Is there an easy way to make a query that selects records where an
expression is returning an #Error?
called "check." In some cases it returns an error in the form of
#Error." I want to add to my query so it will show only those records
that have an #Error in my check field.
I tried entering #Error into the criteria area, with and with out
quotes. I also tried creating a second criteria that says
iif(iserror([check]), "prob", "")
All that does is give me another #Error, if it finds an #Error.
Is there an easy way to make a query that selects records where an
expression is returning an #Error?