Each recipient of my report sees only the information of interest to them.  
My report is grouped by [MchStfIDCode], the page header reflects the
recipient, the page footer starts recounting pages at 1, and so on.
The report has a cover memo.  I can selectively run the report for ...

Hi.  I am having some trouble building a report.  
Each column's info comes from a diff table. The first column comes from the
'main table' and the second and third each have a many-to-one relationship
with the first column. The report I want to create would look like this:

(repost from setupconfig)
I have an ADP that runs stored procedures from a SQL server 2000 database
and now that the table size has reached over 2million records, when we run
the reports, they just cancell them selves with no error being raised.  I

I have created 2 command buttons (using the wizard) that will attach each
report to separate e-mails.  These reports are going to Executive Management
so I am trying to create both .snp attachments to 1 e-mail.   I am a newbee
to VB and understand some code.  I have tried to combine ...

Is it possible, maybe in a TextBox, to run a piece of code in mid-paragraph
that italicizes the following text?  Like this:
="Yada yada important stuff, but " & [ItalOn] & "this is even more
important." & [ItalOff] & "  Don't you agree?"

I have many reports to create and need those which are related to appear
together on one page. I can see that you can create multiple columns for
seperated side by side reports. Is there a way to do create mulitple reports,
one above the other, on the same page?

I have a simple time monitoring table. I work on three tasks every day, so
the table is just:
TheDate T1 T2 T3
------- -- -- --

Printing conditional fiields all in a row on a report.  If a condition is not
true then field is not printed, however, it leaves a blank space.  Is there
anyway to eliminate the blank space and print the next "true" field in its
place?  I'm not talking about overlaying fields.  

In an access 2000 append query, one of my fields is based on the
expression:
[Settings]![ConPath] & "\" & [Contacts]![FName] & "." &
[Settings]![ConExt]

I have a report that has Case Manager Group, and 5 different sub reports
showing cases assigned to the case manager in different programs.  Each sub
report has a count total.  I need to get the total from each sub report and
then total that to show the total cases for each case ...

I have a form that has a subform added to it. The main form is customer
information the subform is customer product data. I have a button that
I use to preview the customer information and product. I want to be
able to view only the customer information that I am viewing in the

I have a form that is used to enter data, when you click print it pops up a
parameter for you to enter your comments in so they will print at the end of
the repoort.  My question is is there anyway to save what you enter into
another table for later use.  In the report my unbound ...

I NEED YOUR HELP!
What I need to be able to do is summarize the data from several variables
and have it appear within a single report.
I want to take a variable that has the values of 'yes' and 'no' and get a

Here is one line of my code:
 DoCmd.OpenReport "rptIssClosedListDate", acViewPreview
and it generates this error:
"Execution of this application has stopped due to a run-time error."

good day,
I have a cost/profit report that I use based on my qryinventory. when I run
my report I am getting the above error... below is my SQL if that will help
solve the problem..