Hi i created a report using the wizard, and when i generate a report i want
to like have column lines so that u can distinguish one column from another

In my Access 2000 database: I have a report with a subreport which requires
mutliple parameters.  After I have input the parameters and see the report, I
must input the parameters again to print the report.  Is there a way to avoid
inputting the parameters a second time?

Is it possible to do a summary listing each page number with a field total
next to it?
Ex:
Page 1    $5,655.78  (page total from first page)

I do psychological research and I use Access 2003 reports to automatically
fill in fields for each person participating (ie I print out questionnaires
as reports with the person's name, ID#, and other person-specific fields
filled in).

I'm trying to sum an amount in a group footer on a report from a query.  When
I change from 4 decimal places to 2, it rounds.  Clearly you can see the
total is off by .01.  Please HELP!

All,
   What is the best approach to printing one Envelope from an Access
application? Currently, my application (Acc 2000) allows the user to print a
form letter for a specific customer using vba code to move data to a Word

I have a form that has three buttons on it. Button 1 prints Report 1. Button
2 prints Report 2. Button 3 prints Report 1, then Report 2. The reports are
identical in design but print to different printers (although they are both
Panasonic KX-P3196 printers).

Access 2003. I have a report that has a control in the group footer whose
control source is defined as:
=Sum([PLEDGED])
PLEDGED is in the underlying query (the reports record source) and is

I would like to have a text field in the grouping header of a report (sorted
quarterly) to result in "1st Quarter", "2nd Quarter", etc. for each
appropriate quarterly group.  How would the control source formula for such
look?

I have a report that shows work orders completed by department (group total)
and by hospital (grand total).  The detail section shows the work order
information with 2 subreports work order hours and parts cost.  The 2
subreports show the total hours and total parts cost for that ...

how do you add a control to an already designed report? I have a completed
report but i have forgotten to place one control from another table in this
report when i used the wizard to create it.Is it possible to do this?

Does anyone know if a Report Group can be removed programatically at
runtime?
I know we can use the CreateGroupLevel method in VBA to add groups, but is
there a method than can remove groups?

I have a field that calculates a number.  In the footer I want to count only
the numbers that are less than zero.  What expression doI use?

I have a report that pulls data from a linked SQL Table.  One of the fields
from the linked table is a text field.  The carriage returns and line feeds
show up as sqaure boxes in this text field.  How can I format this field on
my report so that when the sqaure box shows up it ...

I need to have a total of a sub-reports' control at the end of the
main-report. But when I put a reference to controls of sub-report on its main
report, it causes a #Name? error.
could anyone help me to make it??