Is it possible to get Access to ignore not recognizing a field name using some sort of error handling?

[xy...@hotmail.com]

I have a query that is pulling from a crosstab query with years going across the top. Depending on which years the user selects in a form, some years may exist at one point and not at another point.

I query the crosstab to bring it back to a "Flat" file format for other purposes, but i'd like to query all POSSIBLE years that might show up in the crosstab file. However, when one of the years isn't there, then the query won't run. I'd like to do something with ISerror but that doesn't work... something that will just throw zeros or nulls into the crosstab I'm pulling for for each possible year.

[John W. Vinson]

On Thu, 18 Apr 2013 07:21:10 -0700 (PDT), xy...@hotmail.com wrote:

>I have a query that is pulling from a crosstab query with years going across the top. Depending on which years the user selects in a form, some years may exist at one point and not at another point.
>
>I query the crosstab to bring it back to a "Flat" file format for other purposes, but i'd like to query all POSSIBLE years that might show up in the crosstab file. However, when one of the years isn't there, then the query won't run. I'd like to do something with ISerror but that doesn't work... something that will just throw zeros or nulls into the crosstab I'm pulling for for each possible year.

You can specify that the crosstab should have all the headings, whether or not
there is data for them. See the Crosstab Help topic and look at the section
"Specify fixed values for column headings".
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com