I am trying to create a report that looks like a report from excel.
I have two tables; tblProviders and tblBenefits
I want the report to look like this:  
BC, DD, SS = Providers

I have a report with the following groupings:
1.) Claimant
2.) Group
3.) Carrier

I have a report that uses from a query.  When I run the query, the criteria
box pops up one time.  I fill in the info I need and the query runs.  Great.  
However, when I run the report using the query, the criteria box pops up six
times.    I'm having the problem with several ...

When I run a report, which contains sub-reports, the first time the
information on the sub-reports displays. If I run the report again - even for
the same data - the sub-reports are "empty" - nothing. If I close the mdb
file and open it, the sub-reports show data on the first run ...

=Hour(Nz(DSum("[FTEnd]-[FTStart]","tblMain","[BEMS]=[PilotAssign] AND
[FTStart] Between Now() And Now()+7"),0))
The formula works perfect if I substitute the Now()+7 portion of the
equation with a dummy date (e.g. - 09/30/2007).  Is there a different way I

I have:
TRANSFORM Count(tblCandidates.CALL_RESULTS) AS CountOfCALL_RESULTS
SELECT tblCandidates.CALLED_ON
FROM tblCandidates, [tblDaily Blast]

I have two logos I need to have show up in report header both when viewed and
printed.  As I have them now, they are OLEUnbound embedded.  I have several
reports that have these same logos.  I would like to link them to a folder
where logos are stored.

I  need to get as many lines as possible on each report page - with readable
font size. The default spacing between lines is too large. How do I reduce it?

I'm finishing an application in access 2007.
I tried to install the application on the computer with no access 2007.
It was running well but when I tried to test the reports, they don't open?
What's happen?I can not understand this bug.

Hi - I'm having a difficult time figuring out why I am getting the
error #Name? in all calculated fields on my report.  I have verified
that the name of the control is not used in the expression and that
there are no erroneous spaces in my expression.

I am trying to use conditional formatting to have Access seach for certain
words within a field.  My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field.  I set ...

Thanks for taking the time to read my question.
I have to make a report that has the records displaying across the page
(left to right) instead of on a new page.
So I'll need to have my row headers in my first column on the left side of

i have a table with 6 memo-fields. each memo-field is one column of a
report. Each memo-field can contain text that is longer than one page in
the report.
i want a border around every column and it always should end at the

How do i add a Month Abreviation in an access 2003 report?

I have a purchase order database, with two tables that are linked via PONum
field. On my form I have a print button that prints the current record on
screen, with the following Event Code.
stDocName = "Rpt-POs"