Hello again,
Asking for some expert advise.  I have a report that has two sections both
with headers and footers.  in the final footer I have a unbound field that if
the check box is true show the field, if false, Null.  it wiorks great, but

Hi, I am trying to create a report in Access 2003 where I can obtain the
number of rows and assigning the row number in the results like the following
example:
ROW NUM       FName          LName

I have a report where in the detail section it gives a yearly total from a
Yearly Total query.  The years at total appear as below?
2000    500
2001    600

I am loking desperateley for a solution. I store PDF files in a table
in Access 2003 database using the OLE format. Even though the files
are PDF files the field displays them as"Outlook File attachments".
Dbl Clicking makes them opening. Every file is assigned to a

I have a report that has a "project" field.  Sometimes the project field has
data in it, and sometimes it doesn't.  I also have a running sum that counts
the number of projects.  I want the running sum to be hidden when there is no
project corresponding to it.  Currently, when no ...

I have a created a check box (on the table, query & form).  The box will
indicate that a number enter in another field is a place holder.  When I run
the report for that field I want the number (font) to be red IF the box has
been checked.

I have a subreport that I want to pull up data 180 days before the
date on the report.  Any ideas on if and how this can be accomplished?
Please and thank you.

I've gone through past questions here and figured out how to get this to
work, but I was trying to make it a cleaner report and can't get this to work.
I have a Report with two subreports put in the detail section of the main
report.  One subreport pulls schedule data, one pulls ...

I created a FORM that I would now like as a REPORT.  Is there anyway to COPY
it into a REPORT?  If so, how?

Maybe I have a langguage problem in expressing my difficulties, but here is
what I wanted
Normal report based on the normal query:
Year 2005

I am trying to print some envelopes with an Access report bound to a query
which contains addresses and I'm getting a blank one as every other
envelope.  I selected Envelope #10 as the print property and the report is
just big enjoy to hold the sender's address, which of course ...

?

I am using a IIf statement to set the recordsource to format the type for a
text box. i.e. display £value or Evalue depening on country (option of only
2).
=IIf([Currency]=1,Format([Total Unit Price],"Currency"),Format([Total Unit

I have a query with the following equation AVG Hold Time: [Total Hold
Time]/[Total ACD]. Some fields show #error or a zero value (0:00:00). On a
report footer I would like to average the AVG Hold Time by month or even
better take the sum of Total ACD and the sum of Total Hold ...

I have the following code that makes each line red when the number of
workingdays >10:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If WorkingDays2([Date_Filed], [Summary_Date])  > 10 Then