Is there a way to test (from the main report, perhaps in a textbox) whether
a subreport has data or, if it closed because of no data?
Damon

I want to format a time data field to display just the hour and AP/PM.  I see
the topic in Help, but am having trouble using in my query/report.
Thanks for your help!

Access 2003: My report is based on a joined query of two tables. The report
is a notification letter with subreport of related items. The report runs
fine on page one but all subsequent pages show only mailing information and
no subreport.  I have a form running for daily work ...

Is there a character limit in the Expression dialog box when adding fields
together? I can get up to eight fields to total before I get the #Error?
I am trying to calculate subtotals and totals for a report. The report is
bound to the table.

I need to determine if a record exists on a subreport for any given master
record on the main report and if it does what its value is... I have been
trying to putz around with this for a while, but am not seeming to get it...
There may or may not be a record in the sub report for ...

A97 on Win2000 platform, FE/BE using MDE. FE is on PC, BE is on the server.
I've been programming in Access for nine years and have never seen this
before.
I have a report which uses an unbound subreport and MS Graph. Occasionnaly,

Hello
          I have generated a report basing on a query which gives me the
number of cases and trying to display the same on the report. But what I want
to do is, if the number of cases are less than 5, I want to display as "not

Is there a way to create a report header template so that, it can be
used as a subreport in a main report's header section, and so that it
can size itself and adjust it's controls to fit the main report. This
adjustment is needed in case the main report is larger or smaller than

I have a report that groups instructors and lists the courses they taught &
what their grade distribution was for each course.  Eng 104 and Eng 107 are
considered part of Level 100
I have brought in a sub-report that is appearing in the LEVEL footer, using

First of all thank you for reading this.
I have a report that displays actions of a Case. tblCase holds the case
information and the related table tblActions hold the actions performed on a
case.  My supervisors want me to seperate the actions into columns (not

I followed your suggestion and have successfully defined VBA code to draw a
vertical line that Grows/Shrinks (Thank you! ). Now I would like to modify
that VBA code to avoid having to hardcode the x coordinate and instead
dynamically define the x coordinate using the left ...

I wrote a report in Access that was working fine.  I upsized Access to SQL
server and now I link to an SQL table that I open in Access.  Now I get a
#NAME? error on my report.  I checked the field names and all is fine.  Does
SQL server require different expression syntax?  My ...

I have looked at conditional macros and stuff, but still am not certain how I
would apply.
I have two "styles" of inventory items:
- Style ONE are items that I import as finished goods

I have 2 queries and each of them has a date criteria: between [Start Date]
and [End Date].
I have designed one report based on the first query and a sub-report of this
one based on the second query; the only probelm I have is when I run the

I have a field in a table which allows choice of "buy" or "sell" (investment
table).  In the report, I have grouped the "same" stocks.  How do I write a
formula to subtract the sells from the buys?