Grouping on reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 03 Dec 2005 19:12 GMT

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

Reply to this Message

Duane Hookom - 03 Dec 2005 20:56 GMT

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

Signature

Duane Hookom
MS Access MVP
--

> Hello everyone, I am currently working on a database for a local
> newspaper to keep track of inserts to be inserted weekly into papers
[quoted text clipped - 18 lines]
> Thanks,
> Mike

Reply to this Message

Mike - 04 Dec 2005 01:18 GMT

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

Reply to this Message