Good morning All,
I have a form with a command button to open a report ( based on a query )
for the currently displayed record. The report has a subform in it where the
"Child" = UnitSN, and the "Master"= TLAUnit.  here is the code I have used:

when creating a report, data in some fields may not be available. how do I
make the field headings (captions) disappear (hide) when there is no data for
a field?

I have  an access report and want to count the number of entries (non zero)
in two columns.
ex:  Column 1 (person) Column 2 (event 1) and column 3 (event 2)
Sometimes for a person they may have an entry in either or both column 1 and

I have created a report that pulls information through from a table. I am
baffled though as to why one report is acting differently. When the report
first opens it has two incorrect pages at the beggining followed by correct
information on the remaining forms. The first pages ...

Can anyone please help with this problem?  I have a report based on a
crosstab query where columns are years going 9 years into the past including
the current one.  i.e.. 1997, 1998, 1999, etc.  The fields on the report that
are bound to the data appear to be "hard-coded" and ...

I am having some difficulties with a Report / Subreport situation.
I have a report that I am running based on entries in a user form.  My
problem is  I have a sub report within that report that I want to be able to
pass criteria to and I'm unsure how.

I have built a report that also contains a sub-report.
I am building totals for my report and I have run into something I'm not
quite sure of how to do.
In the subreport it lists an amount field called revision_amt and another

Can anyone conceive how I would go about making a contents page at the
beginning of a report, say in the report header?
I have subject headings appearing on each page. What I would like is a page
at the start that also lists these headings, but with the relevant page

I have a date range as paramters in the query, how can I show them on the
report?
(Like, as part of the title)
Thanks. (Sorry if this has been asked a thousand times already)

From http://support.microsoft.com/kb/q149127/
Count(DLookup("HoliDate", "Holidays", "HoliDate=#" & TheDate & "#"))
I wonder how come the above expression is true if HoliDate is 5/1/2005 or
1/5/2005 is compared with the [TheDate] which have either one of the value.

I have query that shows items and their sales totals (can have an item listed
more than once). I'd like my report to group items together with a total of
the sales for that item to appear also, sorted in descending order.

Trying to create a chart on a report. The chart is based on a query with the
following data:
             Qtr1 '04          Qtr2 '04          Qtr3 '04     Qtr4 '04
Admin         21                    37                   43           25

I have several reports that I would like users to preview before printing.
When pulling up a report using acpreview, the report appears in a sized
window. Is there a way to have the report appear maximized all the time?
thanks

Is it possible to have 2 detail areas in one report? I'd like to list song
titles on the top half of the report and details pertaining to the above
titles on the second half. Obviously, this requires 2 repeat regions. How is
this done?

I want to truncate the any white space in the field when printed.  I've tried
to use the =trim([field name]) but I keep getting an error instead of the
data in the field.