I have Query1 that is a crosstab query with "Rep" as "ColumnHeading",
"Territory" as "Row Heading" and "Total" as "Value".  I would like to use
that Query to create a report, but I can't use the field names, but they
change depending on the date range/active employees of query.  Is ...

I have a report that has a comments field in the Detail
Section if the my report. What I want to accomplish is if
the comments field is blank, do not display the comments
label or the text box. My code only hides the comments

I have just completed my first datebase in Access.  Now I need to generate
some reports.  The information for these reports are on different tables that
are all linked together by a common field.  An example of what I am trying to
do is:  off the employee table I need the field ...

I want to modify the backstyle and the Borderstyle properties of certain
controls on the detail line of a report depending on the value of a field.  I
have tested the code (below) on both the Detail_Format and the Detail_Print
Event.  In both cases the Me.Detail.Controls.Count is ...

Earlier the Chart used to plot fine with the same query. We recently added
data to the database, and since then we recd a message" Data Mismatch
Criteria". and ever since then if I try to plot the chart using that query,
it just comes up blank.

I have the following checkboxes in a form:[Disposition Other]  [Disposition
Repair]  [Disposition Rework]  [Disposition Use as is]. In the report if
[..Other] is check I want have report print "O" for [...Repair];
"Rep", for [..Rework]; "Rew", and [...Use...]; "U".  It is probably ...

I have the following checkboxes in a form:[Disposition Other]  [Disposition
Repair]  [Disposition Rework]  [Disposition Use as is]. In the report if
[..Other] is check I want have report print "O" for [...Repair];
"Rep", for [..Rework]; "Rew", and [...Use...]; "U".  It is probably ...

I want to modify the look of certain controls depending on their value (ie.
highlight the bad ones).
Using both the Detail_Format & Detail_Print Events I discovered that the
"Me.Detail.Controls.Count" property always has a zero(0) in it regardless of

I have a page header section and want the sum of sales
that currently appears in my Sales footer to also appear
in my page header.  Is there a way to make this happen?
Thanks,

In just almost everything, even in start-up we get an error report. It says
send don't send. And I almost always hit send and nothing seems to get fixed.
Like I said before it is not only in one certain spot, or  on one certain
thing. Please help!!

I have a report with 4 subreport, I need that this subreport are not
expandible, but I don't want to cut the subreport.
When the subreport need another page, this continuos in the second page of
the record

Is there a way to add a watermark or semi transparent
image as a background to an Access report ?
Thanks in advance

Hello, I have a table with many fields and records, I'd like to know how can
I select a record and then print the report of this single record only!
Thank you
Roberto

I have a database for some surveys carried out where the answers are either
"Yes" or "No" How can I calculate the stats for the no. of replies that are
yes and no for one column.
Thanks.

I have a report based on a crosstab. The crosstab will return a varying
number of columns depending on the user-defined criteria. I want the report
to print all of, and only, the columns generated through the crosstab.
The column display data from individual stores, so depending ...