I have a report with 5 subreports. Each subreport will print an undetermined
amount of lines, depending on what the record set will be! Lets say for
examples sakes,  subreport#1 will print 10 lines. Right below subreport#1,  
subreport#2 will print 12 lines. Now, lets say on this ...

I have a report based on a query that has five fields.
They are CustomerName, TreatmentName, ProductName,
Quantity and Cost. The query has several different
companies.  Each company may have several different

I have a most strange problem with my report.
The main report is based on a query that consists of
several tables. The subreport is based on 1 table that
list the calculated results of prorated charges.

My customers runs a visual basic application against a microsoft sql server
database. So far I have made theirs reports in access. I think access workes
great, I have yet not faced one report that I could not make. What I not
like is that I have to send the entire mdb file every ...

I was using Access 2000 and all of my reports worked fine. We got new
computers with Access 2003 and none of the reports will open. Even if I
create a new database I still can't create a report.

I have a report that needs the first page to be portrait
and the second to be landscape. Is there a way to do
this?  I can make a subreport for the second page but
still dont know if just this page can be landscape and

I am working on an access report where I have one coloumn called Reward, its
currency, now I want to create some more colomns to calculate the no of
20,10,5 pound notes in that reward. so first column wil be where I want to
calculate the no of 20 pound notes in that reward, and ...

I have a query that is used for purchase orders.  The number of records
depends on the number of purcase order lines.  That works fine (5 polines, 5
records).  The query also links to a table that provides notes for the PO, 1
record per 1 line of note.  In my query, lets suppose ...

hello
         I'm trying to use a chart in access 2003 report, with the data
being taken from a query already present in the database. Whenever I select
the query and choose the fields for displaying on the chart, it says: 'You

I have the gist of it figured out, but I'm having trouble with one small
part.  How do I handle fields without data?  
My situation is this: I have built an invoice database and a report that
asks the user to enter start/end dates and to select an invoice approver.  (I

I'm trying to conditionally format a feild in a report so
that if = 1 it's blue, 2 it's green, 4 it's red etc.
I can't use the conditional format wizard becasue I need
more than three conditions.  How can I get around this?

I am trying to create an Access report that will print off individual
applicant information.
The report will be used by the interviewing committee during the interview
process.

I have a small problem with Sorting and Grouping in Access 2003.  I have a
page header and a priority header, responsibility header and detail section
on my report.  The priority header appears on a page when the priority
changes.  If I have multiple pages for a priority, the ...

Is there a way to automate sending a report at a specific time during the
day?  I created the macro to send out the email but how do I tell it what
time to do it. I do not want to run it each day.  
Thanks,

I need to dynamically control whether or not various subreports are visible
and what their SourceObject is set to. The report I'm working on has four
different levels.  The subreports that I want to control are at the lowest
(4th) level.  The code I'm using is: