I have a query that I changed the ORDER BY to something else, but now the
report won't change.  It still displays the same data in the same order.  I
made sure that the Order By in the Report Properties was not being used, Is
there anything that I might have missed?

I have a single report that has 2 text boxes, which by
default are set to not visible. This report can be printed
from 3 different forms. Depending on the form it is
printed from, I want a particular text box to be set to

I am wanting to diplay a number of results using colour codes ie 2=red,
3=blue, 4=green....   Conditional formatting only lets you use three
conditions in one cell at a time, I need at least 20.  Is their another way
around this?

I have a report/sub report.  I would like to add the sum
of the report and the sub report and display it on the
report.  Is this possible?  If yes, how?
Thanks

I have created a report which picks up customer details
including email address & fax number (where applicable).
I would like to email the report - picking the email
address up from the report - or if they have no email

My main report and sub report display on different pages.  
I would like to display them on one.  Also, I would like
to add the total of the subreport to that of my report.
THanks

I need someones help in being able to finish a database I am working on and
have run into trouble. In my FORM  I have a MultiSelect Text Box, that lists
the selections in a single row. It does the same thing in the Report;
however, in the report I need them in a string within the ...

I have table that includes embedded OLE fields, which I
am using as containers for various binary files. I've
made a report based on that table, though it excludes the
OLE objects, since they can't really be displayed

I want to use a Query instead of an SQL statement to filter a report.  I want this same query to be used several times throughout this project and do not want to have to find it in code every time it needs to be changed.  
I have been able to use the SQL code successfully, but I ...

Printing group of reports as PDF via a macro.
Sometimes I print the reports to hardcopy and the
report/form retains the last printer used.
I want to set the default printer for all reports as first

i am trying to construct a chart.  the time should be
listed on the x-axis.  in creating the chart i have it
setup to be in minutes.  when i view the chart 12/30/99
appears on the x-axis along with the time.  How do i get

I have a button on a form which when clicked, opens a
report.  Auto Resize, Auto Center, Pop Up and Modal are
all set to YES on the form.  When the report is opened,
it is behind the form.  How can I get the report to open

I have two reports with the same text box in each.  The Control Source for
each is the same and is:
=Mid([Zipcode],1,5) & "-" & Mid([Zipcode],6,4)
This formula works in one report but gives "#Error" for the other.

I am new to Access 97.  I have a database that tracks quality information
about parts at different stages of production.  
First I want a to identify (via bold, italic, etc.) the parts that do not
meet the specification for any of the data. (I want the data input to the

In my report header, I have the following code to return
the Cust_ID that I have selected in the frmCustDA. If I
leave the Cust_ID blank, it will return all records. How
could I show in my report header if Cust_ID is null, then