good day all,
I have a report with two subreports. I would like that if either of the
subreports have no data, then the subreport will not show up on the report?
HOw do I go about doing this?

How can I make a group footer only visible if the detail section contains
more than one record.  I don't want to see my totals at the bottom of each
group if the group only contains one record.

I know the lifetime limit of controls on a report is 754.  During
developement and experimenting, I hit that limit.
I made a copy under a different name.
I deleted the original.

I have a report which has 7 labels and 7 associated checkboxes, these
are laid out horizontally going from left to right, with the labels on
one line and the checkboxes underneath, i've managed to use code so
that only the checkboxes that are ticked and there associated label

How can I specify in a report definition that I want to print part of a
field?  For example, I have a 10 byte field of which I only want 5 bytes
printed.

I have a table with equipment details linked to 4 other tables for details of
different types of servicings required. eg Bay service, Calibration, Overhaul
etc. Each of these tables have a service due date and are obviously different
from the other tables. The fields in these ...

We have a 97 database that's located on a server, with many people accessing
to enter data.  When I try to design or run existing reports, I have about a
70% chance of encountering an Application Error that says "The instruction at
0x77f5f30c referenced memory at 0x09420000.  The ...

I have an MS-Access 2003 database (db).
The db has over 500 laptop. Of the 500 laptops, several are old & out of
warranty...
I created a query to identify the legacy laptops. From this query, I created

I have a form where the user clicks on an option button and it automatically
sends 4 reports over to Adobe.  Thanks Stephen Lebans for your code - that
works great!  Sometimes however it seems to "hang" after sending over the 2nd
or 3rd report.  I get the message "Error # 2046  ...

I'm trying to create a report from a cross-tab query.  I want to base the
cross-tab on specific data by Division and Location.  I'd like to total the
PO's per day and then by therapy.  It would kind of look like the below:
Division, Location

I have an expression in a query counting the number of days between 2 dates.  
On my report I would like to average the number of days counted in the field.
I cannot figure out the expression to use to average these numbers.  Can
anyone offer any suggestions?

I have a report with several sub-reports.  How do I prevent a sub from
printing and taking up space if there is no data in the sub for the record
it's tied to?

With this code (below), my intent is to pass the
filter to the report. I assumed that this form of
OpenReport would automatically cause the
reports FilterOn property to become TRUE

I am trying to create a report layout that when run it will create an
individual report for each summary type.  For instance, I have inventories
and I would like a separate report (not just page) for each inventory but I
only want to run the report once and have it create each ...

I have a POLICY Table of Contents in a database.  I want to generate a report
of the items that begin with a letter - i.e., "a", then "b", etc.  I'm new to
Access and can't figure out how to accomplish that.  Any ideas?
Janet