We have been using access 2000 on our network for
6months, on the main form is a print button that prints
forms based upon the patient type that is selected UCASE
only on one users 98 machine has this just started to

Is it possible to programatically, from VB, change a detail report to a group
report, ie, do not print the details, just the group totals?
If so, how can this be done?
This is for Access 2002.

Good evening,
I am trying to add a summary section which gives total
fees paid. My data is in the following format:
Jurisdiction   Land Use    Fee Paid

I've done this before, but can't figure it out for the
life of me and have been unsuccessful with the help menu.
I want to add a detail section after the report header in
order to provide summary data.  How do I insert this

Gentelmen,
trying to add all currency fields of a table
and show it at the bottom  of a report.
I made a query using the wizard that adds the totals fine.

I'm using Access 2002 to generate a report with formatted pages that
must be faxed to recipients.  Each page must fax to a different
recipient with a unique fax number.  250 page report generates 250
faxes etc.  # of pages varies from week to week.  Currently printing

Need some help-- tried to research the answer but all the stuff I
tried didn't work.
Have an Invoice report for students. When the price field is
calculated and comes out to $0.00 I just want that text box either to

Using Access 2002, Windows 2002...
we are having a bit of a problem where reports are
printing out of sequence.
in a module, we set the pointer to a number, then tell

I have a form with multiple records. When I get to a particular record, I
would like to send that record only to a report. When I try, it sends all
records to the report. I have seen it done but am unsure how it tos set it up.
Can anyone shed some light on how you can send a ...

I would like to have my report have the sum totals from two differrent
queries.Is this possible and if it is, what are the steps involved in getting
these results?
Thanks

Hi, i found this code to find records between two dates. but. there is an
error when i try to find records in this month (10). the format is:
dd/mm/aaaa. note: this program start 2 or 3 weeks ago.
when i tried to look between 20/09/2004 and 30/09/2004 all is ok. but when i

I have a form with a command button that previews a report
with a group on teachers and a group heading
called "GroupHeader2".
I want to place a check box on the form called "ckNewPage"

I have fields that do "Sum" of other fields in the report.
When the report is empty, I get ERROR in the fields with
the sum calculation.
I tried to add this condition:

I'm trying to setup a database for a church and I have two problems
with the types of numbers in the phone list.  The current list has
columns for 4 phone numbers for each person with all the different
types throughout.

I've designed a form letter as an Access report.  Is there
a formatting property like in Word to format my letters
when I print them (printing is done by clicking on a
command button on my Access form).  The right margin is