Unanswered: Report with Fields that may or may not be present
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?
Any other suggestions?
Thanks for your help, Mitch