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
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: