I have a form that uses a drop-down value list to fill in the RATING field
with the following values: 'A', 'B' or 'C'.  When I print a report based on
this form, rather than having a single text box for RATING that displays one
of the three variables, I need the report to display ...

I have set up a report from a query which prints a invoice type report. I
tired to write code to only print one report at a time. I couldn't get that
code so I tried only bringing up one record by using a parameter in the
query. When I print the report I get the report the way I ...

I am trying to produce a report that lists all the personnel from our area
offices in a list and then list all of the branches that report up to that  
area office.  I tried subreports, but it produces a new page for each area
employee.  Is there a way to do this?

In Access 2003 I've created an form Option Box w/3 values (displaying as 1,
2, 3). In a report how do I display the values as text?
Option checkbox 1 Value=1  Report should display text=Active
Option checkbox 2 Value=2  Report should display text=Repair

my information on the report comes from a crosstab query, I want to do some
calculations on the report footer but am not sure how to... ie the
ontime/total produced
                          W2           1040        1099

I know that there is a way to set a report to print to a specific printer
but can't it.  Any help is appreciated.

I used the following code to hide the PageFooterSection of my report on the
first page:
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)

I have a report that groups & sums data first on Category, then by Status.
The Detail section contains multiple text boxes to display the detail records.
For most Status criteria I want the report to display the detail, however,
IF the status is "CurrBudget" I want it to hide the ...

When i put a chart into a report, all of the lines and fonts seem to be
'scaled up'.  I literally need to set my title and axis label to 5 points (at
which the true type scaling turns into blocks) to make it remotely normal
looking.

I want to assign a recordset (ADO 2.5) to a report, where i can to see all
records from there.
How can i do it?
thanks for all information about it.

I formatted a date field in a crosstab query which I created a report from.
I'm trying to sort the report by date (month) and would like the sort to be
in assending order, but instead of sorting by assending order of the calendar
month, it is sorting by alphabetical order of the ...

I have several reports that I originally created to print with a alternate
PDF program. I have since removed that program and upgraded to Adobe
Acrobat. Now every time I want to print these reports I get the following
error message:

My report has layout like this :
- Report Header
- Page Header
- InvoiceNo Header

I thought I already posted this but I don't see it.
I have a control in my name footer for each page of a report that I
need to sum for the report footer page. The control is
=IIf(([peas])>0,[text32]+[ptotal]+[stotal],[text32]). I can't figure

I drew a line right on a footer bar and can't remove it. Can anyone
help. You can see it when you preview and print but I can't find it to
remove it.
Thanks