I am creating a report that performs calculations that are stored in Text
boxes.  One of the Text boxes divides two values to give me a percentage.  I
would like to place another Text box under the calculated value that says
something like "If the calc'd value is <= 90, color ...

I am having a problem getting the group total to agree with the sum of the
items.  The total is rounding and is .01 over or under the correct total.  
Since this involves dollars it must agree.
How do I fix it?

I created a report called WeeklyPractitionerRevenue.
There is nothing in the Report Header.  However, there is
a Page Header that has the Pracitioner Name at the top.
Also in this section is the field names for the report

Hi Debbie,
The data of my report comes from query1, I like to put date on this report
which is defined in table 'Mydate' and field name is 'Mydate'. On the
report, in the textbox23 which is going to show the date, I put

I have an Access report which displays a picture of the corresponding data by
referencing the file path in the table.  The problem I have is the file names
of the phots are not consistant.  For example the path might be
c:\pictures\R311.jpeg and another might be c ...

Hello everyone, is Conditional Formating possible in Access 97 Reports.  I
have a few reports and I would like to highlight values that are less or
equal to 0.  Please help, thanks.

I have created a report from my unmatched query which shows the group and
names of students who not did a specific task. The report shows all names
and the group selected. Now I want to show on the report the name of the
task the student not made. How can i refer in the report to ...

I need courses to be sorted in the way that I specify, not by default
alphabetical order...is there a way to do that for a report?

I am unsure how to select one detail field to perform a calculation.
Within the Detail Section I have:
Status and then Days of the month across the page.
When the report is run I have 6 lines with the different status available.

I really try to do this stuff on my own first.  I am trying to open a report
from a field in a form.  The field is the autonumber/primary key for the
record.  The field is IssID and I tried the following code.
Dim strWhere As Integer

I gety the error message "cannot open any more databases' when opening a
report with a subreport  in Access2000.
The message does not appear on all computers that I am running it in. Once
the error appears and you click Ok it will open in Preview and show all

I have created a report but only want it to display the currently filtered
records from the table and not the whole table.
Or...  a prompt for the value in the field to be filtered and displaying
only those filtered records would work.

I have calculations setup within my quiries and when info is inputted into my
forms the output only shows on my forms.  So how do I create a report that
will show the output since access doesnt let you create reports from forms?

How do I get a weekday name to display in a report e.g. "Wednesday, March 9,
2005"

Can I put a picture as background in a mailing label like I have done in a
report?  My attempts have resulted with the picture covering the complete
page of labels.
Thanks, TomC