Grouping on reports

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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
 
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
 
Back
Top