Perhaps i misspoke. Here's the scoop. What i need for people in our company
(3-4 people will use the layout I am looking for) is the ability to select a
group of records, see them on screen, place a show/hide button for each
group, and then print. All should be done as fast as possible, as they may be
doing 25-30 at a time. Each Report will be anywhere from a few lines to 20
pages. A Pivot Report is interactive as well as a Drill Down datasheet. But
these people are not computersavy so I have to engineer a report that they
can easily interreact with. They want to type a job order, select a list,
check the status (thru the on-screen report), select the groups to show and
print out the final list. They will then hand it off to stock people and
gather parts.

Right now i have a continuous (tabular) form to show data and check off
those lines or groups that don't need to print. In the header i have a Job
order text box, a command button that is keyed to accept a new work order
that is typed in the text box and a macro button to print the report. The
report reads the Job Order text box to retrieve the query parameter. All of
this involves a few queries, a macro, a report, and a couple of tables. It
would be nice to pare this down to a form and a query and a table. It could
then printed in the layout that our Main database program prints (block
report style for easy readability, although that program is slow and requires
several dialogue boxes to select data). My current method works. But as their
needs change, i'd like it to be easier to create new reports. Or is this
about the best way to do this?

The report, per se, is not interactive but it's about the flexability to
create the printed report. I appologize for upsetting Klatuu (Klatuu, Barada
Nicto) but Microsoft, in my opinion, has a small problem with the Report
section of Access. Although i mostly love Access, i detest the Reports
section. You have to build the report, then create triggers, and then print
it out. You can't e-mail directly. You have to have a viewer (it has to be
installed on all the computers, and IS/IT dept. freaks out).  the html method
is ok but some of the formatting gets screwd up. Or you have to make a
template. If you want to link Excel data or into Word, hmm. It's late and i'm
rambling.

But my take on the definition of report is a "statement". When you get a
report, someone always wants to "spin" it, so they can understand it better.
If a Pivot Report is an interactive report (of course it has some faults of
it's own), is there something that can be done to make the Access reports
more e-friendy for less experienced users who expect interactivity? As my
coworkers always say "Great! I've got all the info I need. Now, how can I
shorten the list and make it easier to read." There's just no satisfying some
people.

Sorry to offend. If ignorance is bliss, then why aren't I smilin'?
thanks,
Jackle