How do I add a grouping level to an existing report in Access?

I hoped that the SP1 will fix the problem, that I cannot assign specific
printers to reports.
I have just installed the Office 2007 SP1,
but still I cannot assing specific printers to reports.....

I have been using this format to band all my reports
Text Box 1
Name: txtCounter
Control Source:=1

I have an unbound text box in a report where I want to do a simple calculation.
IIf [UnitCount] has data then [UnitSize]/[UnitCount]
IIf [SubUnitCount] has data then [UnitSize]/[UnitCount]
I can't seem to get the syntax right. Any help would be appreciated.

Hi microsoft.public.access.reports,
In access 2000 on window 2000 pro, I have a table including the
following fields:
Field Name:              Data Type

How can get a message box to pop up when there are no records in a report
that says, "No Records"?  On my switchboard I have a list of reports, when I
click on button report will display data and if no data it displays blank
page.  I rather a message comes up saying no records ...

How can I export a Report to excel?  I can't just export the
underlying query, because I need to keep group header and footer.
thanks, John

I have one project in MS Access.
In that I have one form in which I am using one combobox and one
search button.
Now when I select an item from that combobox and press the submit

Is this possible?
I created a report but some of the results span more than a page, or two.
It has a  coulmn in it that has inv. Amounts. I want to be able to put a
Total Invoice Amount at the bottom of each page, for the invoices on that

2nd one is dependent on 1st one,

Why can't i create a report ?
When I press 'Create report in design view' nothing happens.
When I press the wizard I can do the wizard as usual, but the ends with 'The
wizard is unable to create your report'.

Hi, all!
Something really weird happens to one of the reports in our
application.
There is some field that gets it's value within the Detail_Print event

I have a problem that just occured - suddenly I can't open my reports in my
database in any fashion - except for one???  You click on them and nothing.  
Funny thing is one of the reports that I worked on last, works perfectly!!  I
checked other databases on my computer (microsoft ...

I'm trying to create a report that compares revenues received this
year/qtr/mo/wk with revenues received last year in the comparable
year/qtr/mo/wk, and additionally by sales division and sales manager.
I have the data stored in a table with fields: SlsDivID, SlsMgrID, DtRecd

I tried to search for this one but not sure how to word it.
What I am trying to figure out is how to make a report that adds all the text
from a query together and displays it in one field.
For example: