test for error in if statement

[Randal]

I have a cross tab query that provides the fields for an append query. It
works fine until there is no data to create one of the fields then the 2nd
query errors out looking for the field. Is it possible to test for this
error in the second query and have the second query supply dummy data? For
example:
iif( error exists, 5, [Field1])

 

[[MVP] S.Clark]

No. To work around this, you can create a semi-permanant table of which you
write the crosstab into. This guarantees that all of the expected fields
names will exist. A second method is the use of the ColumnHeadings property
of the query.

Thy the latter first, then the former if extreme measures are needed.

 

[Randal]

ColumnHeadings property was the answer. Thanks

No. To work around this, you can create a semi-permanant table of which you
write the crosstab into. This guarantees that all of the expected fields
names will exist. A second method is the use of the ColumnHeadings property
of the query.

Thy the latter first, then the former if extreme measures are needed.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

I have a cross tab query that provides the fields for an append query. It
works fine until there is no data to create one of the fields then the 2nd
query errors out looking for the field. Is it possible to test for this
error in the second query and have the second query supply dummy data?
For
example:
iif( error exists, 5, [Field1])