C
Chip
I have created a report that is based on a crosstab
query. The problem I am having is that the result set is
not always constant on my column headings or data. I
would like to create a report format that allows me to
just execute the report and generate the most recent
information from my crosstab query. Unfortunately, as I
create and save the report (and rerun it after result sets
have changed), it now generates an error: The Microsoft
Jet Engine Database doesn't recognize '[09/08/2003]' as a
valid field name or expression. It wouldn't, being that
the information is no longer being pulled up in the
crosstab query on which the report is based. Can someone
help here in getting this report to be more dynamic in
it's creation of field definitions?
query. The problem I am having is that the result set is
not always constant on my column headings or data. I
would like to create a report format that allows me to
just execute the report and generate the most recent
information from my crosstab query. Unfortunately, as I
create and save the report (and rerun it after result sets
have changed), it now generates an error: The Microsoft
Jet Engine Database doesn't recognize '[09/08/2003]' as a
valid field name or expression. It wouldn't, being that
the information is no longer being pulled up in the
crosstab query on which the report is based. Can someone
help here in getting this report to be more dynamic in
it's creation of field definitions?