Report based on qry not printing correctly

mousemat

Completely Self Taught
Local time
Today, 04:19
Joined
Nov 25, 2002
Messages
233
I have a report based on a qury. The query contains four field, pretty simple stuff and shows the correct data when run.

However, my report is basically a letter going out to particular groups, the groups are in the query. Its only one page long.

Each report lists one or more members depending upon which group they are. I think I have the groupings correct. There are 15 groups of members

My problem is this:

As the query is run, it pulls data from the table and shows that I have four members for the first Group (1st Meopham) however, it prints one page with only one member and the second page with the other three members, each subsequent page is correct, ie it shows the correct number of members per group per letter. It prints 16 pages for only 15 groups, two pages for the 1st Meopham group where it should only print 1

What's going on here, have I missed something???
 

Attachments

Last edited:
Without looking at your zip file, report grouping is not controlled by the report recordesource, but by the report sorting and grouping property.
 
The grouping and sorting have been set so that the Group header is Ascending, the Forename is also set to Ascending.

The problem seems to occur when the data for the first group has two or more people to be printed. It always prints the first page with only one person and the second page with the other people.

Seems very strange to me but can't seem to work out why it's happening. Anyone have any ideas?
 

Users who are viewing this thread

Back
Top Bottom