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 person 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.
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 goning away. All I want to
change in the base query is one selection parameter, such as event #1, event
#2, event #3 etc.
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 person 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.
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 goning away. All I want to
change in the base query is one selection parameter, such as event #1, event
#2, event #3 etc.
Any help will be appreciated.