W
w-wonka
I have a set of queries setup to provide data to a set of reports. The
report format is designed to print standard mailing labels (Avery 8160, 3
col. by 10 rows), with differing info and formatting based on the query group
per event.
When I change the selection query for another event, the report format goes
away. Specificlly, I have a qryGreen to select all persons in a green group
for lets say event #1. The query feeds the rptGreen Report that prints
labels (std Avery 8160, 3 cols.). If I change the query so that it selects
the Green group for event #2, the report formatting goes away and prints only
one column. I have to rebuild the report from scratch, using the same query,
to get the 3 cols back. It seems the Report will only work once, and then
the formatting goes away.
What is going on here, and how can I keep the base query so that it feeds
the same report format, without the report format going away. All I want to
change in the base query is one selection parameter, such as event #1, event
#2, event #3 etc. I would not expect the report format to go away by
changing one selection criteria of the query.
Any help will be appreciated.
report format is designed to print standard mailing labels (Avery 8160, 3
col. by 10 rows), with differing info and formatting based on the query group
per event.
When I change the selection query for another event, the report format goes
away. Specificlly, I have a qryGreen to select all persons in a green group
for lets say event #1. The query feeds the rptGreen Report that prints
labels (std Avery 8160, 3 cols.). If I change the query so that it selects
the Green group for event #2, the report formatting goes away and prints only
one column. I have to rebuild the report from scratch, using the same query,
to get the 3 cols back. It seems the Report will only work once, and then
the formatting goes away.
What is going on here, and how can I keep the base query so that it feeds
the same report format, without the report format going away. All I want to
change in the base query is one selection parameter, such as event #1, event
#2, event #3 etc. I would not expect the report format to go away by
changing one selection criteria of the query.
Any help will be appreciated.