I've set up a report where one of the fields comes from a lookup table. The
lookup table has an autonumber and description. for example 1=Complete
Response, 2=Partial Response, 3=Stable Disease. When I look at the report it
only shows the number. 1 for Complete Respose etc. How ...

I have a report being driven off of a query on a table of survey
responses:
                                         Question 1      Q1 Comment
Q2     Q2Comment     Q3............

Is it possible to conditionally draw a line connecting two text boxes
on a report?  The text boxes would be conditionally positioned on the
report based on their values.  I've figured out how to do that, but
now I need to connect the dots, so to speak, to try and make it look

How do I apply conditional formatting that evaluates two criteria.  For
instance I need the field to change colors if the the date =  today and
Completed = no

I want to export an Access report to Outlook email or MS Word.

I have created a Gantt style report based on the example found at:
http://www.access.hookom.net/Samples.htm
This works fine but I would like to create a report by employee that will
show when they are free/busy. I can get it so all of the projects are on a

I have a report grouped by company name so that each conpany prints on it's
own page(s). My header is in the page header. I'd like to supress printing of
the header on the report footer page. Not sure how to do this. I'm sure this
is an easy one for some of you.

I created a report on Data base and the columns a-s are missing for
consequence my reort information is missing.  
How can I get it back to show a-s?

I'm trying to calculating an averge handle time using total number of
processed emails divided by the total handle time. However, since the time
could be longer than 24 hours, I'm using the following expression
=Int(CSng(Sum([Handle Time])*24)) & ":" & Int(CSng(Sum([Handle

I want to summarize shipments for a customer showing (Item No., Total Qty
shipped, Last Shipped Date)
I used a group by query and Last on the Shipped Date but the results on the
Shipped Date are sometimes wrong.  How do I ensure that the Last Shipped Date

In the detail section of a report called Payment Receipt , I display the
result of a query, Expr2, in a text box.  (This will be a number (dollar
amount) that is different for every record.  FYI the text box is also called
Expr2.)  If that value = 0, I do not want the page footer ...

I have created a report (column) that list open invoices and I have also
attached a sub-report (different table) that displayes comments.
Problem: sub-report is showing for all invoices, but I would like it to show
ONLY for invoices that has a comment.

I have a database tracking parking leases in a parking garage.  The data
comes from two tables - one table has general information about companies
whose employees have parking leases, one table has more specific information
on the leases given to the employees of the various ...