Is it possible to get Access to ignore not recognizing a field name using some security!

[Dan Ashley@abc com]

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

xy...@hotmail.com
Apr 18
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.
Click here to Reply
John W. Vinson
Apr 18
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