I have a crosstab query that I run on scrap reasons for specific parts.
The query will return different "fields" based on what it finds for the parts I give it.
My problem is that the report I made (which has all the potential fields--scrap reasons) comes up with errors about missing fields when those returned "fileds" are not present in the query, and won't continue.
How can I deal with these sometimes there fields? Is there a way to trap for that error and let the report continue? If so what is the error?
Thanks.
The query will return different "fields" based on what it finds for the parts I give it.
My problem is that the report I made (which has all the potential fields--scrap reasons) comes up with errors about missing fields when those returned "fileds" are not present in the query, and won't continue.
How can I deal with these sometimes there fields? Is there a way to trap for that error and let the report continue? If so what is the error?
Thanks.
Last edited: