Printing a Report

[szczmj70]

I have a box database setup and I have to create a report based off of that
database to attach to the outside of the box that indexes everything that is
inside. I am using a subdata form to control the data and everytime that I
print out the report, I get a report for each file that is included. Is there
a way that I can limit the printout to just one report and not a report for
each individual file listed in the subdata sheet?

Thx.

- Matt

 

[Jeff Boyce]

Matt

We aren't there, we can't see what you're working on.

What's a "box database?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[szczmj70]

Sorry.

I have created a report to print out what is in each of the boxes that I
send to an off-site location. All of the materials are listed using a
subdata form. My problem is that once I print, it prints me a copy of the
same report for every one item in my box. That means if I have 10 items, I
get 10 reports. I just need one report to printout so that I can tape it on
the outside of a box. Hope this clarifies.

- Matt

 

[John Spencer]

The source for your main report is probably returning one record for each
item. You need to trim that. Probably by removing the items table from the
main reports record source or not showing any fields from the items table in
the main source query and using the DISTINCT word in the Select clause.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..