Report skipping some groups

  • Thread starter Thread starter bblines
  • Start date Start date
B

bblines

Guest
This may be kind of tough to explain. I don't understand
what's going on!

I have 2 tables: a board information table, and a member
information table. I use these 2 tables to take care of a
database of boards and commissions and their members.
This is newly created from scratch to replace a single
table '97 database doing the same thing.

When changes are made we print a report to keep on hand
here in the office. Very simple report grouped by board
and listing the members alphabetically.

Works great, except for one thing:

For no apparent reason, it groups 2 particular boards with
the previous board. 2 out of about 70 boards, the rest come
out grouped correctly each on an individual page or pages
until the current board is complete.

The Board Name is used for grouping. The primary key for
the board table is Board ID.

Settings appear to be correct on "Sorting and Grouping"
interface.

The fields for the two tables are as follows:

Board Table:
Board ID - Primary Key - AutoNumber
Board Name - Text
Code Section - Text
Length of Term - Text
Number of Members - Number
Notes - Text

Member Information Table:
Board ID
First Name
Last Name
Middle Name
Title
Street Address
City
State
Zip Code
Home Zip Code
Home Phone
Work Phone
Fax
Position
Representing
Sex
Race
Date of Appointment
Term Expiration
Date of First Appointment
Non-Voting or Ex-Officio Member
Member ID - Primary Key

The SQL for the report is as follows:

SELECT [Board Information Table].[Board Name], [Board
Information Table].[Code Section], [Board Information
Table].[Length of Term], [Member Information].Title,
[Member Information].[First Name], [Member Information].
[Last Name], [Member Information].[Middle Name or
Initial], [Member Information].[Street Address], [Member
Information].City, [Member Information].State, [Member
Information].[Zip Code], [Member Information].[Home
Phone], [Member Information].[Work Phone], [Member
Information].Fax, [Member Information].Position, [Member
Information].Representing, [Member Information].[Date of
Appointment], [Member Information].[Term Expiration],
[Board Information Table].[Number of Members]
FROM [Board Information Table] INNER JOIN [Member
Information] ON [Board Information Table].[Board ID] =
[Member Information].[Board ID];

All the records are output, there is just a problem with
the grouping on 2 or three boards.


Anyone have any ideas? I'm about to pull my hair out!

Thanks,
Brad
 
Last edited:
It's grouped by Board Name sorted ascending and sorted by Last Name ascending.
 
Is the problem just with the report or does it also show up in the query? you'll need to sort the query by the same fields that the report sorts by to see.

This may turn out to be a corruption problem. Try compacting and repairing the db. You mignt also want to download the Jet repair probram from the Microsoft download site.
 
Are there Boards with the same names? Try to sort on the key values as boardID
 
No all of the boards have different names, however some of the boards have the same members requiring different records in the Member table due to different appointment dates and positions.

I will give this a try and post back.
 
I got it! I needed to set the "Force new page after selection" in the Group Header properties.

Duh!

It's always the little things.

Thanks for the effort guys.
 

Users who are viewing this thread

Back
Top Bottom