I have a report where I need to display various levels of member
participation.
Originally I displayed the level including the non active members:
="18 =" & Format((18/(Count([surname]))*100),"#.##") & "%"

First time working with subreports.  I have worked with sub forms.
With Sub forms, you have child and master fields.  Looking at the
Northwind database, you have the same thing with reports and sub reports.
So I have my master report and my subreport built.  I use the toolbox to

I create a form and a button on the form. When  I click the button, the code
would send information to the report to be printed out. However, data show up
on the report only when I debug line-by-line (there are no error at all. I
open connection to the database and recordsets). ...

Is it possible to get Access to highlight specific records in a report
without grouping them differently from the rest of the records. One could
e.g. use a date for when a record was added and get the database to mark that
record with a color based on a comparison between (now) ...

I'm using the following code:
Private Sub cmdRunRpts_Click()
Dim strSQL As String
Dim rsIPTs As DAO.Recordset

I need to create a report from a query. This one will have 23 fields. I can
not seem to fit them in there nicely. I've try different ways and I still
can't get it to work.
Anybody has any ideas or suggestions. Should I add a sub report to the main

I am working with MS Access 2002 and don't find on the property sheet of an
report the OnPrint Event or On Print Property.  What do I have to do or
programm to get this event?
Thanks

I am printing labels on 20 labels sheet. Occassionally a blank record is add
to to the table causing the blank label on the first label of the sheet.  
This causes the 20th label to print on a second sheet.
What can I do to prevent this from occcurring.

I have a report of an audit trail of logins.  The Query does not sort but the
records are in TIMESTAMP order.
Display fields:
[TIMESTAMP]  in mm/dd/yyyy hh:nn:ss AM/PM (Default format no Format command

I have a subreport that I would like to only be 2.5 inches long.  It can't
take of any more space.  However, I have a list of 15 items that won't fit in
2.5 inches.  I would like the list to go for 2.5 and then wrap to another
column and hopefully have three columns going across.

I have a field that I want to sort by in my report.  The possible values
comprise the numbers 1 through 9, 10S, 10N, 11, 12, "claims," "NYC," and
"OCA."
The report insists on listing the categories "10N" and "10S" in between the

This is really, really, weird!
I have this report that has 50 columns on which I plot date ranges. In
certain columns I print letters to indicate special dates e.g. L=Letter date,
D=Due date, E=Extension date.

I have a  2003 report that prints labels three across and several dow.  If
there are only a few labels to print and some of the labels on a page are
alrady used, how do I print the labels on an existing label sheet to spots
where the labels have not been printed to before.

Can someone tell me how to use the filter in
docmd.openreport rptname,display,filtername
How do i set the filter for a report, does it refer to an additonal query?
pierre

I have a report that the user does a between date lookup to run the report.  
I feed the report with a from the field [enl Date] with the code of
Between [Enter Start Date] And [Enter End Date]
It works great but I need to have a label on the report that will give the