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

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.
 
J

John W. Vinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top