Grouping on reports

M

Mike

Hello everyone, I am currently working on a database for a local
newspaper to keep track of inserts to be inserted weekly into papers
that go to different post offices. I am having trouble getting the
report to display the way that i want it. I ran a query to gather the
postoffices and inserts that go for the current week. I want the report
to display something like this.

postoffice1 insert1
postoffice2 insert2
insert3
--------------------------------
postoffice3 insert2
postoffice4 insert3

I am unable to get the grouping correct. Acces is only allowing me to
display 1 post office per page instead of grouping all the post offices
that have the same inserts together.

Any help would be greatly appreciated

Thanks,
Mike
 
D

Duane Hookom

You base you main report on your table of insert groups. Add two
side-by-side subreports: one for PostOffices and one for Inserts.

Your insert groups table is related to Inserts (inserts that are grouped
together). Then there is a table of PostOffices that receive the insert
group.

tblPostOffices
=============
PostOfficeID

tblInserts
=============
InsertID

tblGroups
=============
GroupID autonumber primary key

tblInsertGroups
============
GroupID
InsertID

tblPostOfficeInsertGroups
==============
GroupID
PostOfficeID
 
M

Mike

Duane thats a good way of going about it. Thanks. My next question is
whats the best way to make the inserts groups because there is never
really any set groups. 1 week i could have 3 groups the next week i
could have 17. It all depends on who gets what that particular week.
Hope you know what i mean i don't think i explained it to well.

Thanks Again
Mike
 
Top