all records on one page

[Jacqueline]

Ok, I have done this before but cannot for the life of me remember how. I
need to group all records pertaining to one customer on a one page letter.
Example:

One customer has three dogs. I need to send a renewal letter to the customer
and want all three dogs showing up on one letter, to run in a batch with all
the other owners.

I have query that pulls all my owners by renewal year, the PK is an account
number that is also attached to each dog in the dogs table. The query runs
fine but now matter how I try to group the report, if an owner has more than
one dog it prints to the next page... AHHH! If anyone else, besides me, is
crazy enough to be doing this on a Sunday night, please help.
Thanks much

 

[Al Campagna]

Jacqueline,
If you have one Customer record in the Customers table, and three dog
records associated to that customer by AcctNo in the Dogs table...
Your report query should look like this when run...
AcctNo Customer DogName
1652 Smith Farfle
1652 Smith Fido
1652 Smith Fifi

Just group on AccountNo (you can set up a Group Header for that) , and
place your customer table data in there.
Use the Detail Section for your associated dog records. The detail
section should list 3 dogs.

* AcctNo Header *
1652 Smith
* Detail Section *
Farfle
Fido
Fifi
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."