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

  • Thread starter Thread starter xyzer
  • Start date Start date
X

xyzer

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.
 
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 to expand...

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
 
Back
Top