** I am trying to create a listing report based on 2 search criteria
(potentially linked to separate queries). This report is based on 2 linked
tables. The question is as short as it can be while maintaining the requisite
level of detail. For the bottom line of the summary, ...

I am building a simple access database in Access 2000.  I have build a form
that has a subform attached.  I would like the print a report that ONLY
contains information for the form data displayed.  Can anyone help?!

I have a report that I am trying to create.  it summarizes failure/pass on a
particular set of exams for both males and females.  I summarized the data
via a crosstab query, and then am trying to create reports.  In some
instances, both males and females took the exam, in some ...

Is it possible to display default text "DRAFT" in bold red in a date field
until such time the date is entered and displays in another color?  I want to
be able to issue a draft report and looking for a simple way to do it.

I have code, below, that pops up a form for a report and the user checks
which subreports should be on the main report.  That works.   However, I want
the code to identify if one of them wasn't selected to "move" the other
reports up.  I have subreports, one after another with ...

Not sure how to explain my question without first giving a quick
overview of my data.
My table is set up in the following format.
Month > Payment Status > Payment Type > CheckAmount

I have WindowsXP.
My customer wants invoices (reports) emailed.
Is there some simple way to do this.  I am
not technical.

Is it possible to make a report in Access that would list the days from 1 to
15 or 16 to 30/31 each day in a column with absence codes and the hours:
                              1       2       3       4
EmpNm                   099  110    099    099

Here is what I have in my control source to convert seconds to minutes:
=[OtherMediaAHT]\60 & Format([OtherMediaAHT] Mod 60,"\:00")
However, when the minutes are over 60, I will see 74:43, how can I add onto
this to make it convert to hours, as well?  (I want to see 01:14:43)

How would I group a report based on a combo box selected on a form.
Thanks

There are four fields in the query design view - START DATE, BETWEEN DATE,
DATE REJECTED and TODAY.
The BETWEEN DATE=(TODAY-STARTDATE) . It works fine.
If the users enter a date for the DATE REJECTED field, they would like to

I am using the DateDiff function to find the minutes an activity takes.  
Since the DateDiff function returns a Variant I am storing it as a Text filed
in the data base.  In a report I am deviding the value by 60 to derive the
hours but am consistantly generating numbers with up ...

I have a report which have set several values to "Hide Duplicates".
I have line under each row of data.  I wish to hide the line if the value in
the previous record is repeated.
I plan on using the "On Format" for the report section to control when the

How do I set up a paper size that's half letter size?

I can't seem to get my charts to stick to a Form that I created with a Pivot
Table.  I can view the chart just fine, but I have to build it each time I
open the From.  When I close the Form, and then reopen the Form, all I see is
the pivot table data. I wanted to be able to just ...